I say it is a bug, and I have noticed this before. If you change '' to ' ' [1 space], you do not get those records [the ones with just 1 space in the memo field] selected.

>Hej!
>
>Can someone exlain what's going on here. It looks like a bug to me...
>
>To setup create a table with a memo and add a few records and some empty
>records.
>

>create table xxx (xx m(4))
>insert into xxx values ('assasa')
>insert into xxx values ('a aaa')
>insert into xxx values ('')
>insert into xxx values ('')
>

>
>I want this query to return the rows that start with 'a'
>

>select * from xxx where xx='a'
>

>
>But it returns all rows!!!! Why?
>
>Note:
>- SET EXACT has no effect
>- happens in VFP 6 and VFP 7
>- select * from xxx where xx='a' and not empty(xx) works ok!