Skip to Main Content

Does anyone have some wizzy code or bright ideas?

563457Sep 28 2007 — edited Oct 5 2007
I have a string variable - varchar2(240) maximum - which is arbitarily filled with 3 letter codes. Any one or more of these codes may be duplicated within the string. What I need to do is to strip out all the duplications and end up with a single contiguous string containing all the unique code options. e.g.

Initial string 'AAABBBCCCBBBDDDAAAEEEBBB'

should end up as :-

'AAABBBCCCDDDEEE'

Hope this makes sense - also there is no need to place the unique codes in any kind of order.

Thanks for your help...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Oct 29 2007
Added on Sep 28 2007
13 comments
5,302 views