I have a table in sql server 2000 which has a column whose name starts with a number("2ndName").

I have a c# code which updates the table by filling a Dataset.
When I issue an update, it throws the following error:-
"Incorrect Syntax near 2"

Query I use to build the adapter is "SELECT id, Name, [2ndName] FROM MyTBL WHERE 1 = 3" and the statement issued to update is "objAdapter.Update(objDSDB, "MyTBL")" when it throws the error "Incorrect Syntax near 2".
Any help to resolve this is appreciated.

Thanks in advance.
Jai