Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Spaces in Table Names

Status
Not open for further replies.
noclist

noclist

MIS
Joined
Aug 13, 2008
Messages
9
Location
US
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?
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question Question
windows command in a sql script
Replies
1
Views
606
carp
carp
BobThornton
  • Locked
  • Question Question
Cross Join in an Insert Into
Replies
1
Views
584
carp
carp
harfri
  • Locked
  • Question Question
Insert into a new table
Replies
0
Views
440
harfri
harfri
mikrom
  • Locked
  • Question Question
from a table with symmetric relation select every pair only once
Replies
0
Views
439
mikrom
mikrom
Davest11
  • Locked
  • Question Question
Table or View does not exist
Replies
11
Views
873
PHV
PHV

Part and Inventory Search

Sponsor

Back
Top