>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

As Hugo hints, SET EXACT has nothing to do with VFP's SQL commands. SET ANSI is the relevant setting.

Tamar