>>In the Help it says
>>"" = "ab" is no match
>>Is this not my case (comparing an empty string to something)?
>
>It's not true for queries because comparison in queries is controlled by SET ANSI not SET EXACT. So in query
"" = "ab"
>*is the same as
>"ab" = ""
and both return True. See SET ANSI topic in the help for details.
So in a Select statement comparing a string to a memo field will return matching memos and all empty memos. Is that correct?
Caroline