Error using CREATE TABLE statement

[meldrape]

Hello, I'm getting an error when trying to create a table that starts with a numerical character, with the following SQL statement:

CREATE TABLE 2004apr25

I get the following error: Incorrect syntax near '2004'. I've tried everything, putting half quotes around it, putting brackets but it won't work.

CREATE TABLE test

works great, no errors because the first character is alpha I guess:
I can manually do it but that defeats the purpose. Any thought would be helpful. Thanks. (asp sql2000)

 

[Genimuse]

Square brackets are always a good way to indicate that you mean a name and not something else, but if you've tried them:

CREATE TABLE [2004apr25]

and they don't work, then I have no idea.

 

[meldrape]

Thanks anyway. Yes, I've tried them and tried them. I've done a response.write on my statement and everything so now I guess I'll just have to change the file name configuration. THanks.