sql 7 - escaping characters 1

[andrewgrax]

I've got a db with special characters in the name (in this case a minus sign)
when I try to use it (with use db-name )

I got :

Server: Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near '-'.

quoting the db-name doesn't seems to work.

any suggestion?

thanks in advance

 

[Glowworm27]

have you tried placing [around the database-name] ???

the square brackets are used for this kinda stuff.

Not exactly sure but I am pretty sure this is what you need to do.

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net

 

[Glowworm27]

I tried it and it worked, just in case you were talking about a table and not a database, I also put the - hyphen in the table name too. Here is the script...

use [db-name]
select * from [table-name]

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net

 

[andrewgrax]

it works!
Thank you!