Query SQL Expression without input

[PriscillaThoopthong]

I would like to be able to query something like this:

If the owner or the secondary owner contain the input value

without the user having to enter the value in both places.  So one input, but it searches both owner and secondary owner.

[ToddW_stl]

hi @PriscillaThoopthong -  the question is a bit vague - where and how are you trying to implement this query?  I would think something like this could work:

OWNER1 LIKE '%partial_string_search%' OR OWNER2 LIKE '%partial_string_search%'

 Here's the SQL reference for query expressions for additional reference.

[PriscillaThoopthong]

Thanks Todd.  This is in Enterprise Experience builder.  There is no option to actually type the SQL.  I am building the query with the UI.  There doesn't seem to be a way to type the SQL.  When I add the query, it displays the SQL like this:

but this causes two input boxes to be displayed to the user.  One for the Owner and one for Second Owner.  I want one input box, but want to search both fields for the same value that the user enter.