You are welcome

>Thank you, Sergey. Both worked and both are clever.
>
>>Try

>>SELECT t1.* FROM mytable t1
>>  WHERE 2 = (SELECT COUNT(*) FROM mytable t2 WHERE t2.Artnum = t1.Artnum AND t2.Catnum IN ( 'INT', 'ISR'))
>>
>>

>>
>>
>>>
>>>Consider the following table:
>>>
>>>

>>>Artnum    Catnum
>>>111         INT
>>>111         ISR
>>>111         GRP
>>>222         INT
>>>222         RSA
>>>222         GRP
>>>

>>>
>>>I want a select statement that says 'give me all the records for a particular artnum WHERE the artnum belongs to a catnum of BOTH 'INT' and 'ISR'.
>>>
>>>This would produce the following list:
>>>
>>>

>>>111         INT
>>>111         ISR
>>>111         GRP
>>>

>>>
>>>Thanks,
>>>
>>>Yossi