SELECT [order detail] AS orderDetail FROM mytable

HTH,

Jeff Garza
  ----- Original Message -----
  From: Claude Schneegans
  To: CF-Talk
  Sent: Wednesday, April 07, 2004 2:36 PM
  Subject: problem with space in table name

  Hi,

  I'm having a problem with a table in MSSQL with name "order detail".
  The problem is that first "order" is an SQL keyword, second, spaces are not allowed in identifiers.
  Beside shooting the guy who designed the databse, is there a solution?
  Like a delimiter I can use around such an identifier?

  Thanks.

  --
  _______________________________________
  See some cool custom tags here:
  http://www.contentbox.com/claude/customtags/tagstore.cfm
  Please send any spam to this address: [EMAIL PROTECTED]
  Thanks.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to