Fabio,
You just made me realize that my second code will not work if the data is not in ascending order, so I will either use STUFF() or Al's code instead.
>with STRTRAN() you should scan loop with the mth in DESC ORDER
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
