>>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'+' '
>
Fabio,
Wouldn't that require all combinations of characters that could be used at word boundaries? I think using regex is better.
Cetin