sql server - Where is the error in my SQL query regarding Invalid Column Name? -


code:

select      [ado net destination].vendor_id,      [ado net destination].vendor,      [ado net destination].address1,      [ado net destination].address2,      [ado net destination].city,     [ado net destination].zip     [ado net destination]      ((([ado net destination].parish) in ("caddo", "bossier", "desoto", "webster"))); 

errors:

msg 207, level 16, state 1, line 3
invalid column name 'webster'.

msg 207, level 16, state 1, line 3
invalid column name 'desoto'.

msg 207, level 16, state 1, line 3
invalid column name 'bossier'.

msg 207, level 16, state 1, line 3
invalid column name 'caddo'.

strings use single-quotes in t-sql:

'caddo','bossier','desoto','webster' 

Comments