>>>>is there a way to look for a word in a memo field text but only find whole words.
>>>>eg: looking for KING should finf Martin Luther King but not lurking
>>>>even if KING is at the beginning of a line or sentence or at the end therof.
>>>>
>>>>maybe REGEX could work, but how
>>>>
>>>>
>>>>Peter
>>>
>>>
>>>? ' '+'king'+' ' $ ' '+'king and I'+' '
>>>? ' '+'king'+' ' $ ' '+'you are the king'+' '
>>>? ' '+'king'+' ' $ ' '+'kingsolomon and I'+' '
>>>
>>thit won't find king. or King at the beginning of a line
>>regex works perfectly.
>>
>>
>>Peter
>
>It will find it, look closer at this solution.
No, it won't
(1) it pads with spaces
(2) it does not use upper() nor lower()
Gregory