Table name = 'ORDER'

[Extentec]

This is an easy one I hope..just can't remeber how to make this happen:

I am working on a program (written by microsoft) run on SQL Server. One of the table names is "ORDER" and the word 'ORDER' being a reserved word in SQL Server generates an error when I try to reference the table:

SELECT * FROM ORDER

Results in a "Incorrect syntax near the keyword 'ORDER'." error. Why they did not name the table "ORDERS" I will never know. Calling it dbRDER also fails.

How do I access this table?

THANKS!

--Eric

http://www.onti.net

 

[Lekar]

Just simple enclose the table name within square brackets:
[tt]
SELECT * FROM [ORDER]
[/tt]