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. ;-)