Hi,

I am trying to use the values from a $REQUEST variable to build the SQL Query statement and I have the Query operating fine. The question is what is the best way to add a "%" to the end of the passed $REQUEST value to ensure the query finds all instances rather than only an exact match?

My query WHERE currently is as follows,

WHERE
({$REQUEST:vLocCountry|empty:""} = '' OR LocCountry LIKE {$REQUEST:vLocCountry|empty:""})

The obvious answer for me appears to be to add the "%" to the value on form entry, but the form seems to not permit the use of "%" and generates an error on the webpage. Any ideas? Even if there is an easy way to force the form to accept the "%" character.

Thanks in advance.

Ken

Hello,

Use the following code:

WHERE
({$REQUEST:vLocCountry|empty:""} = '' OR LocCountry LIKE CONCAT('%',{$REQUEST:vLocCountry|empty:""},'%'))

Regards,
ARI Soft

Thanks very much, your suggestion worked great!

Ken