Database Name including a space

[Phil99]

Hi

I'm trying to access a database, where the database name has a space in the name: ICore DB

This is causing an issue is Query Analyser when I attempt to run a query such as

select count(*)
from ICore DB.dbo.tblCountry

Is there a way to alias the Database name or can the syntax above be modified to allow the query to run.

Thanks

Phil

 

[gmmastros]

select count(*)
from [!][[/!]ICore DB[!]][/!].dbo.tblCountry

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[bborissov]

Select count(*)
from [ICore DB].dbo.tblCountry

All reserved words and some strange names must be included in square brackets to make the query to run.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.