Hi -

Thanks to Ari-Soft's excellent support, I have the following functioning query:

SELECT
CompanyName,
City,
WEB
FROM
sheet4
WHERE
({$REQUEST:City|empty:''} = '' OR City = {$REQUEST:City|empty:''})
AND
({$REQUEST:Cuisine|empty:''} = '' OR cuisine = {$REQUEST:Cuisine|empty:''})
AND
({$REQUEST:Price Range|empty:''} = '' OR price = {$REQUEST:Price Range|empty:''})

I have modified my custom form to include a text box where user can input beginning portion of CompanyName
and would like to modify the query by including a LIKE predicate in the WHERE clause such as
WHERE
({$REQUEST:CompanyName|empty:''} LIKE '' OR CompanyName LIKE {$REQUEST:City|empty:''})
AND
.....(rest of original query).

Is this possible to do and if so, could you provide me the proper syntax for accomplishing same?

Thanking you in advance as always for your excellent support.

Hello,

Use the following:


WHERE
({$REQUEST:CompanyName|empty:''} = '' OR CompanyName LIKE CONCAT({$REQUEST:CompanyName|empty:''}, '%'))
AND
.....(rest of original query)


Regards,
ARI Soft

Hi -

Thanks again for your assistance, you guys are the greatest, worked like a charm