Hi, Gerard-

>I dont know where I got the 'IN' from but I thought you could use it as a VFP $ type function in SQL.

Could be, too, you were thinking of the syntax

SELECT * FROM something WHERE iid IN (SELECT iid FROM 

>I tried Cetins code and it worjed fine.

Cool. Cetin is top-notch. ;-)