Please help with SQL syntax

[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

 

[Sylvain Lafontaine]

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

S. L.