ACE code question

Hi all, I am having some problems writing some reletively simple ace code for a report I am working on. I would be deeply greatful for some suggestions and especially some example code on how to procede. The problem: I have a list of operator ids (as many as 5) per row returned by the select in some ace code. Some rows will have all of the op ids the same, some will have all different ids while still others will have a couple the same ... Let me illustrate. sample id opid1 opid2 opid3 opid4 opid5 --------- ----- ----- ----- ----- ----- 1 JT JT JT JT JT 2 PY JT JT JT JT 3 PY JT JM JT JM . . . . . . . . . . . . . . . . . . I need to output a list of opid's that contains no duplicates. Let me illustrate again. sample id analyst(s): --------- ----------- 1 JT 2 PY, JT 3 PY, JT, JM . . . . . . For reasons that are too complicated to explain here I cannot use a UNIQUE clause in the select hence my post. Any help with this would be appreciated. TIA, Stu Miller -- ______________________________________________________________________ _ / \\._ _|_ _.._ o _ Stu Miller - Data Management Tech \\_/| | |_(_|| |(_) internet: millers@ndm.gov.on.ca ____ _____ ___ e-mail: miller_s@torv05.ndm.gov.on.ca / ___| ____/ _ \\ voice: (705)670-5635 FAX:(705)670-3047 | | _| _|| | | | _ | |_| | |__| |_| | _ _ ._ o _ _ _ / _ ._ _|_ ._ _ \\____|_____\\___/ _>(/_| \\/ |(_(/__> \\_(/_| | |_ | (/_ Geoscience Laboratories Ministry of Northern Development & Mines 933 Ramsey Lake Road, Sudbury, Ontario, CANADA P3P 1G9 -----------------------------------------------------------------------