Using the LIKE operator 1

[JanCampbell]

Are there any known restrictions/problems with the LIKE operator?

I have a very simple selection formula:
{CONTACT.JOBTITLE} like "*director*" which is returning 0 records.

I have also tried:
{CONTACT.JOBTITLE} like "*" + "director" + "*" which also returns 0 records.

There are records in the database to match the criteria.

Any other options to try?

Thanks in advance for any help.

 

[Naith]

Is {CONTACT.JOBTITLE} actually in lower case like your post suggests?

Try this instead:

LCase({CONTACT.JOBTITLE}) like "*director*"

Your selection criteria is case sensitive. LCase forces lower case. Remember that the LIKE operand is not great for performance, as indices get ignored.

Naith

 

[JanCampbell]

That has worked. Thank you very much. Didn't realise was case sensitive but am aware of performance issues - no way around though unfortunately.
Thanks for your help.