(annoying? No. A honest quest for knowledge is always a good thing :-) )

Not an easy one..(at least for me). Maybe you could write an UDF (User
defined function) that parses and recreates the string in a sorted order.
Also, beginning V5R4 there are several recursive and ranking functions in
SQL, that could be of help. Unfortunately, in our shop our 520 was stopped
at V5R3 :-(


Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact