>>>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
>
>I believe, it's documented under LIKE() function and LIKE Operator. The more confusing part is, that they both have different symbol, so I have to check Help when I'm using them.
Referencing SQL LIKE operator is dangerous IMHO. Because it reveals much more capabilities of LIKE where VFP version doesn't support - at least in VFP6:(
Cetin