>
>So in a Select statement comparing a string to a memo field will return matching memos and all empty memos. Is that correct?

Yes. The same would happen if you use ALLTRIM() on the character filed in the query.

... UPPER(ALLTRIM(mycharfield)) = "ABC" ...

will return all records with empty mycharfield in addition to the records that match.