>>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.
If it's not broken, fix it until it is.
My Blog