Space in table name 1

[junkjones]

I need to query a table that has a space name in it. (I know I know - it wasn't me that named it).

I've tried these three versions:

select *
from [Price Index]

select *
from "Price Index"

select *
from 'Price Index'

And I always get the error: Invalid object name 'Price Index'.

What is the correct syntax?

TIA

 

[JamesLean]

The first one should work.

Check the owner of the table. It may be that you need to qualify the tablename:

SELECT * FROM [owner].[price index]

--James

 

[junkjones]

BINGO! That's exactly what I was doing wrong - thanks!!!