How to query a table with a hyphen in the name?
Posted on 2010-09-17
I have a database that has a table with a hyphen in the name (don't look at me, I didn't do it!). Let's call the table E-Mail_Addresses. I need to query that table. The database is Intersystems Cache, but it accepts standard SQL queries.
I need something that looks like
SELECT * FROM [E-Mail_Addresses] WHERE Name='JohnDoe'
Except that I need it to work. If it matters to anyone, I'm coding in VBS using ADODB and the InterSystems 5.1 ODBC driver.