Table names in Microsoft SQL with hypen

[Eindride]

Hi.
I want to access some tables in a Microsoft SQL 2000 database. But the tables
has names with the character "-" (hypen).
I understand that this is not "legal" in normal SQL, but an "extension" in
Microsoft SQL.
My problem is that I can not make SELECT queries to theese tables. Queries to
other tables (without hypen in the name) in the same database is woring fine.

I have tried several suggestions with characters like ' and [ around the table
name in the query without success.
I have also tried
- Updataing the Microsoft SQL 2000 driver
- Updated DataDirect JDBC drivers (version 3.5)
- Configuring the Microsoft SQL Server 2000 JDBC driver

Sadly, I may not change the table names. The database is a part of a big
soloution for imposition and printing newspaper pages.
For a long time I have been looking for somebody with a similar problem
without success.

Can anybody help me?

[kim il sung]

this syntax doesnt work?
SELECT [au_fname], [au_lname]
FROM [pubs].[dbo].[authors]
ORDER BY [au_lname] ASC, [au_fname] ASC

[Eindride]

Here is an example of a query that does not work:

<cfquery name="Recordset1" datasource="ArkitexMain">
SELECT *
FROM dbo.Tb2005-09-12$NAT$ONE$$_
</cfquery>

PS! Tablenames with the "$"-character works OK. The problem is the "-" (hypen).

[Dan Bracuk]

Originally posted by: Eindride
Here is an example of a query that does not work:

<cfquery name="Recordset1" datasource="ArkitexMain">
SELECT *
FROM dbo.Tb2005-09-12$NAT$ONE$$_
</cfquery>

PS! Tablenames with the "$"-character works OK. The problem is the "-" (hypen).

kim il sung suggested square brackets. Did you try that?

[Eindride]

Thank You! Thank You! Thank You! Thank You! Thank You!

I have tried a lot with square brackets around the "hole name" like:
FROM [dbo.Tb2005-09-12$NAT$ONE$$_]

But the solution was very simple:
FROM dbo.[Tb2005-09-12$NAT$ONE$$_]

I?m very happy right now! Tell me what to do in return.

Thank You kim il sung and Dan