views:

594

answers:

3

I am trying to set every row's CheckColor to Blue in the table tblCheckbook (why the hell do people add tbl to the start of every table, I think I know it's a table).

I'm using this query

UPDATE    tblCheckbook
SET       CheckColor = Blue

However, Microsoft SQL Server Management Studio Express complains Invalid column name 'Blue'.

This has to be a simple fix. What am I doing wrong?

+7  A: 

use 'Blue' not Blue

le dorfier
+9  A: 

Try this:

UPDATE    tblCheckbook
SET       CheckColor = 'Blue'
gkrogers
+4  A: 

Try adding quote around Blue

UPDATE tblCheckbook SET CheckColor = 'Blue'
LeJeune