Getting LIKE %you%

[Chuck Pelto]

Okay....

...I ask a simple question....

...what is wrong with this SQL search text?

SELECT recID, * FROM tbl_cont WHERE cont_namecomplete LIKE '%may%'

It seems to me to be perfect. However, I'm not getting any returned  
records from the call...

   thisCursor = App.tDatabase.SQLSelect(sqlString,   
EVCursorLocation.kServerSide, EVLockType.kReadWrite,  
EVCursorDirection.kRandom) // where the sqlstring is the search text

I know there is a record in there where cont_namecomplete includes  
the word "May".

Regards,

Chuck