Re: Remove duplicates from a field possible?

>> we store in a var field values in the format 123; 345; 567; In some
>> records the field contains duplicates, i.e. 123; 345; 123; 567; Is it
>> possible to selelct those records somehow, or even better get rid of
>> the duplicates?

It'll be easier to help you if you provide the following:

• Oracle version
• The DDL of the above-mentioned table
• Some sample data

HTH -j Received on Mon Mar 06 2006 - 08:03:37 CST