All Forums Database
aolympio 25 posts Joined 04/09
03 Apr 2009
How can I use a reserved keyword as a common field?

Hi!I have one table that has a filed called "" and RELEASE is reserved keyword.That is my query:SELECT , FIELD1 FROM TABLE1 ORDER BY It doesn't function so How can I use a reseved keyword as a common field?Thanks for help,Anderson

Fred 1096 posts Joined 08/04
04 Apr 2009

Use quoted identifier syntax:SELECT "RELEASE", FIELD1 FROM TABLE1;

aolympio 25 posts Joined 04/09
06 Apr 2009

Thank you so much for help!

You must sign in to leave a comment.