SQL Select Statement

[user612345]

I'm trying to pass a SQL statement through C# but my SQL statement needs quotes around a table since the name of the table is also a proper SQL command(which I have no control over).

Looking at MSDN I tried the following two methods but.

string sqlSELECT = @"select * FROM tableNAME.""SELECT"";

string sqlSELECT = "select * FROM tableNAME./"SELECT/"";

The problem is that both of these statements above leave in slashes.

[boudino]

They should be backslashes...

string sqlSELECT = @"select * FROM tableNAME.\"SELECT\"";

... but the sql looks weird at all.

[user612345]

Whoops meant to put backslashes in but still the end result will come out with slashes in the SQL statement.

[DataMiser]

use [ ] around reserved words or names that contain spaces in your sql string


Select * from [Select] where [User Name] = ....

[user612345]

Thats what their called, reserved words, had I remember that would have solved this without assistance.

Thanks you though.