Getting LIKE %you%

[Sims, John (CDC/CCHP/NCBDDD) (CTR)]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of Chuck Pelto
> Sent: Thursday, May 24, 2007 3:37 PM
> To: Valentina Developers
> Subject: Getting LIKE %you%
> 
> 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


Hi Chuck,

My first thought:  does it contain "May" or "may"?  I can't remember if
LIKE is case sensitive or not but my first thought is that it is case
sensitive.  A quick look at the wiki docs may answer this question.
Sorry I don't have time to look at them myself.

-John