Ok Thanks for all your comments
I was aware of the alernative == , but was just trying to find an explanation of why it would not work !!
Regards,
Gerard


>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