Hi Brandon,
Sorry, I wasn't clear. When I said "empty memo field" I meant that there is nothing stored in the memo field. It's equvalent of zero-lenght string. In SQL Select with SET ANSI OFF SPACE(0) is equal any string on the right, so SPACE(0)="test" is true. Outside of SQL Select SPACE(0)="test" isn't true. The character fileds in VFP have fixed lenght. The 'MyNonMemoField' field even if it's empty is filled with spaces.
>Why then, does this not affect non-memo fields the same way?
>
>For example the following statements give the same result set:
>
>BROWSE FOR MyNonMemoField="test"
>and
>SELECT * FROM MyTable for MyNonMemoField="test"
>
>But substitute memo fields and then all empties are included with the Select statement but excluded with the browse statement.
--sb--