Very simple SQL quest

Question

SELECT Id, to, Subject, Body, DateCreated, DateSent 
FROM Emails

Gives the following error:

Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'to'.

Any idea why?

TO is highlighted, so I guess, it is because it thinks that is a keyword, anyway to prevent this?

Cheers.

Also see: http://stackoverflow.com/questions/2901453/sql-standard-to-escape-column-names — Oded, Apr 10 '12 at 12:36

score 5 · Accepted Answer · answered Apr 10 '12 at 12:34

5

Yes, put to in brackets like this [to]

answered Apr 10 '12 at 12:34

Eric Petroelje

2

Or alternatively if you want to be compatible to standard ANSI SQL use double quotes: "to" – a_horse_with_no_name Apr 10 '12 at 12:35
You can also not pick such inane words to be field names. – JNK Apr 16 '12 at 17:25

score 0 · Answer 2 · edited May 23 '17 at 10:34

0

You escape it by surrounding it with [] (SQL Server specific):

SELECT Id,[to],Subject,Body,DateCreated,DateSent 
FROM Emails

You can also use the standard SQL escape, " as detailed here:

SELECT Id,"to",Subject,Body,DateCreated,DateSent 
FROM Emails

edited May 23 '17 at 10:34

Community

answered Apr 10 '12 at 12:35

Oded

2 Answers2