>>>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()
>
>I agree with upper/lower/proper, but what's wrong with the spaces except for CHR(13)/10 ?
In summary, you would have to make special provisions for:
Beginning of text
End of text
Beginning of line
End of line
Any relevant punctuation marks
If you do a replace (chrtran() should work fine in this case) for each and every of those cases (just add a space for the first two), then the search will work.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)