Reserved SQL keywords

usertom
12-17-2003, 06:45 AM
The designer of the database i am querying has named a column as "current".
This is an SQL reserved word.
Is there a way to refer to this column in a select query?

thanks

00100b
12-17-2003, 06:46 AM
Place the field name in brakets.

SELECT [current] FROM TableName

usertom
12-17-2003, 06:55 AM
thank you, thank you, thank you.
its so obvious but i couldn't find that explanation in any of my 3 SQL books.
cheers

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum