Jamis Buck wrote:

> Seems to me the "standard" (as if there were really a reliable SQL 
> standard) is to double quote column and table names (if quoting is 
> needed), and single quote string literals:
>
>   UPDATE the_table
>      SET "group" = 'test'
>    WHEN id=1


SQL Server also support putting the column name (or anything else, for 
that matter) in brackets:

UPDATE [mydb].[dbo].[the_table]
    SET [group[] = 'test'
    WHEN [Id] = 1

and the like...


-- 
She drove a Plymouth Satellite
Faster than the Speed of Light...

http://www.joeygibson.com/blog
http://www.joeygibson.com/blog/life/Wisdom.html
Atlanta Ruby User Group http://www.AtlRUG.org