Hi all,

I also had a problem with using var in "IN" clause...

but for case that you describing you can try something like this

select * from sometable

where userid in (select userid...

You can check this site http://www.cizer.com/