my data is like this (when you join Person and Vehicle):

Person Id VehicleType Transatcion seq

A1 ...

the problem is that vehicle_types not in (20) has a number of values that I don't know for the NOT condition. So I'm trying to check only with the vehicles...

I tried that IN (05,10,15) but if the person has 05 and 20 , it returns that row as well.

Does IN work like this? choose rows where vehicle -...

I should have added this in my previous post:

I also want the resultset to contain persons with even one vehicle from that list.

The following are acceptable:

05,10,15

05

05,15

10,15

etc...