Sintax Error

[mrprogman]

Hi How are you....i got a database in progress , and I got one app in ASP.NET 2008, i got one field in the database call 'sup-id', how can i make a select to this field from one query like this

Select ord.onum,ord.cdate,ord.expected, ord.sup-id From pub.ord

when i try with this query, i got this error....

[h=2]OR [HY000] [DataDirect][ODBC OPENEDGE driver][OPENEDGE]Syntax error in SQL statement at or about "[sup-id] From pub.ord " [/h]
can you help me with this...thanks

 

[RealHeavyDude]

You must enclose the field name in double quotes to avoid the syntax error as the field name contains an illegal character - which would be the dash ...

Heavy Regards, RealHeavyDude.