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?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.