The character string comparison is controled by SET ANSI in SQL Select and by SET EXACT everywhere else. In addition when SET ANSI OFF and SET EXACT OFF MyMemoField='test' is true for empty memo field in query but not in the BROWSE.
>Why does
>SELECT * FROM MyTable WHERE MyMemoField='test'
>
>not give the same result set as
>
>SELECT MyTable
>BROWSE FOR MyMemoField='test'
>
>
>Using VFP7SP1
--sb--