Unable to use 'Group' as field name in INSERT or UPDATE

[Guest carloss]

I get the error "Syntax error in Update statement" in the following SQL:

 

UPDATE Tasks SET Group = 'AAA' WHERE Proj = '5'

 

If I change the name of the field from Group to something else the error goes away. Is this a problem with the SQL VB.NET parser?

 

I want to use Group as a field name. Any other way of doing it?

[divil]

Tried putting Group in square brackets?

[quwiltw]

divil's suggestion should work, but I'd offer another one: Rename your column. While sql server gives you a workaround (the brackets), I think it's generally a bad idea to use keywords as column names. I'm sure others may differ.