SQL Update with Boolean Problem

[TheDrParker]

When I try this:
UPDATE [Certifications] SET [Verified] = 'True' WHERE [Employee Name] = 'Buttros, Peter' AND [Certification] = 'MCSE' AND [Verified] = 'False';

I get:
…[SQL Server]Syntax error converting the varchar value 'False' to a column of data type bit.

And when I try this:
UPDATE [Certifications] SET [Verified] = True WHERE [Employee Name] = 'Buttros, Peter' AND [Certification] = 'MCSE' AND [Verified] = False;

I get:
…[SQL Server]Invalid column name 'True'.

What am I doing wrong or missing?

 

[tlbroadbent]

In SQL Server there are no built-in True and False values. Use 1 and 0 instead. This is an Access Query and Jet SQL forum not SQL Server. You should post SQL Server questions in forum183. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.