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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer