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
Post a Comment