Please help with SQL syntax

  • Thread starter Thread starter Aleks
  • Start date Start date
A

Aleks

I am trying not to select records if they are IN a comma delimited session
variable, it works fine If I want to select the ones IN, but not the other
way around:

Select * from users
where Users.UserId NOT IN (1,2,3,4,5)


Is this correct ? how should I change it to make it work ?

Thanks for the help !

Aleks
 
Your example is perfectly OK, so the reason for your problem must be
something else.

S. L.
 
Back
Top