• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • Last Modified:

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'
0
rgb192
Asked:
rgb192
1 Solution
 
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now