I'm running Coldfusion MX 7 and querying SQL Server 2000. I can query normal table names with no problem. However, I have a large database with table names formatted as follows
My question is how do I reference a table named in this manner in a SQL select statement? I've tried it in quotes and replacing the $ with a period and nothing works. Coldfusion gives me the following error every time: "Invalid Object Name". There are hundreds of these tables named this way and it isn't something I can change.