>Hi Fred,
>
>it is good on not english language, but AND can to be used on text strings:
>
>

>sWhereClase=" zuppaId=345 AND LIKE('*you and me*',textNote)"
>

>
>Exact search require syntactic analysis of the string.
>
>Fabio

I suppose that's true, that it could be part of an imbedded string. I guess I rarely would ever see that as I'm not usually searching for text in fields in a SELECT.