>>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?