>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

This might work for you too...
Select * from MyTable where EMPTY(MyField)