Spaces in Table Names
Spaces in Table Names
(OP)
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?
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?
RE: Spaces in Table Names
"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