retrieving data from table name contain 2 words, no underscore betwee

[avivit]

Can I retrieve data from a table, which named in 2 words,<br>with a space (not underscore).<br>In other words, how can I modify the query so the following will work:<br>select name from emp name order by name<br>(Please pay attention that is a space in the table name, and there's no possibility to change it to underscore.)<br>Does anyone know the answer?<br>Thanks in advance

 

[DougP]

Put brackets around anything with spaces<br><br>select name from [emp name] order by name<br><br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[avivit]

Thanks a lot DougP, it works perfectly.<br>You've delivered me a great help.<br>I appreciate it.