How to handle a hypen in server name??? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to handle a hypen in server name???

I am trying to query a couple of tables, using linked servers
with an openquery function.
The servers were originally named with hyphens in them…
How do I handle the hypens in Query Analyzer? any help would be appreciated.
Brackets: [my-server]
SELECT * FROM [server-name]… Thsi shud work, or try to create alias for Linked server name rajiv
Thanks! [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by merrillaldrich</i><br /><br />Brackets: [my-server]<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">