[DB-SIG] RE: SQL Query Help

[Ryan Weisenberger]

Thanks everyone for your replies!  The double quotes did the trick.

- Ryan

>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