Certainly an easy question,
but I can't find the information.

In Access db, in my SQL statement I used this syntax for boolean field :

... where myfield=no
... where myfield=yes

After an SQL Server migration (upsize)

This is not accepted.
So I am looking for the SQL equivalence
(The field has become a "bin" field)

Thanks for this info,

Is there a good documentation on SQL statement on the Net ?

Pierre.

Hello,

I have moved your post to the access forum.

Best regards

Manfred Peter
(Alligator Company GmbH)
http://www.alligatorsql.com