[DB-SIG] SQL query help

Ryan Weisenberger ryanw@inktomi.com
Wed, 07 Mar 2001 12:07:02 -0800


Does anyone know how to get at tables with spaces in the name?  The 
Microsoft SQL Server 2000 demo database is loaded with tables with names 
like "Order Details".

I've tried a few combinations:
c.execute("select * from order details")
c.execute("select * from order-details")
c.execute("select * from order_details")
c.execute("select * from 'order details'")
c.execute("select * from order%20details")

All of these return a syntax error from the SQL parser.

Does anyone know the correct syntax for this?

- Ryan