It's how VFP does with string comparisons.

The item on the left is compared up to the length of the field on the right. Because length on the right has a length of 0, it basically looks at SUBSTR(right, 0, 0)

Try SELECT * from MyTable WHERE MyField == ""

The double equal sign means exactly equal

>Hi
>Why does the following select ALL rows ?
>Select * from MyTable where MyField = '' && Two single quotes without a space in between
>
>Does not matter whether Set exact is on ot off
>Tia
>Gerard