>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
Gerard
Try an extra =
Select * from MyTable where MyField == ''
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.