zachvaldez
asked on
What is data type equivalent for yes/no in MSSQL?
IN access you can set the ddata type to Y/N. What is the setting in MSSQL/ thanks
Keep in mind, depending on how you set up DDL, a bit could be 1, 0 or NULL, not just 1 or 0. NULL doesn't equal anything, not even another null, so your comaprison code should always test for a true condition and set to false if not true.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SELECT CASE WHEN ColA = ColB THEN 1 ELSE 0 END as myBit
FROM ...