Expression soLike

rbuser

Hi

Is there available a case insensitive expression for soLike?

This only works on an exact match so soLike = 'BRENT' would find BRENTWOOD
but not Brentwood.

Any ideas for a work arround?

Thanks in advance

Philip L Jackson

nicocizik

Hi Philip,

The LIKE keyword is a function of your database. If you need it to be
case insensitive, you can see if your DB supports the UpperCase or
LowerCase functionality. In SQL Server the function is UPPER() or LOWER().

You can try using these routines in the field name and value of the
search tab or as manually edited SQL.