select varcharcolumn from table where varcharcolumn not in ('term1', 'term2', 'term3')

select varcharcolumn from table where varcharcolumn not in ('term1', 'term2', 'term3')


is this the correct syntax for 'not in' for a 'varchar'
LVL 1
rgb192Asked:
Who is Participating?
 
qasim_mdCommented:
Your Syntax is correct. If you are using the exact same SQL and getting error its is just that you are using table in your from it is a keyword so you will get an error

try this, this will not give an error:::

select varcharcolumn from [table] where varcharcolumn not in ('term1', 'term2', 'term3')

did that help ? let me know...
0
 
rgb192Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.