SQL Update with Boolean Problem 1

[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?

 

[jitter]

The bit column is like it says, it only will store a 1 or a 0. Try substituting a 1 for true and a 0 for false and you should be all set.