How do I programatically acces a database with a '-' in the name?

[Evelyn Schwartz via SQLMonster.com]

use this-is-a-stupid-name

returns an error

For that matter

select *
from this-is-a-stupid-name.dbo.anytable

returns an error

I've tried single quoted, double quotes, escaping. In the SQL editor I can
select the name from the dropdown and I'm OK - but I'm writing a perl
script to connect to the database.

I didn't create the database and don't know how it was created.

--
Message posted via http://www.sqlmonster.com

[Simon Hayes]

"Evelyn Schwartz via SQLMonster.com" <fo***@SQLMonster.com> wrote in message
news:1f******************************@SQLMonster.c om...

use this-is-a-stupid-name

returns an error

For that matter

select *
from this-is-a-stupid-name.dbo.anytable

returns an error

I've tried single quoted, double quotes, escaping. In the SQL editor I
can
select the name from the dropdown and I'm OK - but I'm writing a perl
script to connect to the database.

I didn't create the database and don't know how it was created.

--
Message posted via http://www.sqlmonster.com

See "Delimited Identifiers" in Books Online:

select * from [this-is-a-stupid-name].dbo.anytable

You can use the QUOTENAME() function to add the identifiers.

Simon

[Evelyn Schwartz via SQLMonster.com]

Thanks works like a charm. Half the battle is knowing where to look!

--
Message posted via http://www.sqlmonster.com