Query on a keyword field.

[DeltaWind]

I have a table with one of the fields named date(how in the world anyone could name a field 'date' beats me). I want to do a simple select, on that field, but I keep getting an error. i think it is because it is a key word. i know in msSql, you wrap a key word in []. how do you query this field in sybase. I can query any other field without an error, I can even do a select * with no problem . it is only when I do a 'select date from mytable' that it bombs.

help. I don't know anything about sybase.

 

[SilvaMuppet]

Delta

Have you tried SELECT <table name>.date from <table name>

just a suggestion , this works in general....not sure if it will for a column named after a keyword.

Silv