How to turn from Access to Microsoft SQL statement

[ki ki]

Hi
I am developing a program that can work with Access or Microsoft SQL server. I used different syntax for SQL statements. It works fine with Access. When i try with msSQL i got one problem that i don't know how to solve.I use one column - yes/no type and when i import tables to msSQL database,the column turns to bit type(0 or 1 values). When i want to update at msSQL, I can't use the "NOT" as i use in Access in below statement.

UPDATE Table
SET Column = NOT Column
WHERE (ID = 1);

I found online but can't find that topic.
Really appreciate the help!

 

[Logan]

Hi
UPDATE Table
SET Column = NOT Column
WHERE (ID = 1);

I found online but can't find that topic.
Really appreciate the help!

You have to change all your SQL statements to use "1" instead of "true" and "0" instead of "false".

 

[SubSpace]

You should be able to use Column = ~ Column on MS SQL.
(~ is the binary NOT operator)

 

[ki ki]

Thanks a lot subspace. i use ~ and it works. I really appreciate ur help. Thanks to Logan too. )