Spaces in Table Names

[noclist]

I have a table named 'Order Details' that cannot be renamed. When I try to work with it, I get syntax errors I'm assuming are related to the space in the table name. I've tried all combinations of quotes to fix this issue but to no avail.

ex "Order Details.name"
'Order Details.name'
"Order Details".name
'Order Details'.name

Obviously these don't work but I couldn't think of anything else to try.

What is the proper way to deal with this?

 

[r937]

since you posted in the ANSI SQL forum, the proper way to deal with it is to use doublequotes, which is the standard

"Order Details".name

if this doesn't work for you, then obviously you're using a database system (and you neglected to mention which one) that doesn't support the ANSI standard

helps?






r937.com | rudy.ca
Buy my new book Simply SQL from Amazon