Symbols in column names

[bugg_tb]

Whoever designed this database thought it'd be a great idea to put a minus sign in the doc-id column header, so in a sql query how do I ask it to look at pub.blah.doc-id without it giving me a syntax error?

Cheers

Tom

 

[Casper]

pub.blah."doc-id" would do the trick.....

Casper.

 

[bugg_tb]

Cheers Casper

Its one of my small SQL bug bears, not aimed at Progress but they all have to be just slightly different syntactically dont they

Tom

 

[Casper]

Yes they do
BTW all our table have a dash "-" in their names, so that's fun writing queries :awink:

Casper