>>Cetin
>>
>>>>select * from mytable where myMemo like '%'+lcSearch+'%'
>>Just tried this, and it works! Thanks. I would have never figured this out...where does the % operator come from? All my usual sources just show this as the modulus operator for arithmatic.
>>
>>Thanks again.
>>
>>--- Larry
>
>It comes from SQL itself. I don't know where it's documented more detailed but check 'Select - SQL command'. Examples 8-11 (not 11 it might confuse).
>'%' and '_' stand for wildcard chars in SQL 'LIKE' operator (* and ? in DOS).
>Cetin
BTW if you would use this purely in VFP then
atc(lcSearch, mymemo) > 0
might be better because it's case insensitive (upper(myMemo) like '%'+lcUpperedSearch+'%' would do the same and portable).
Cetin