• Hugo Kornelis (9/30/2014)


    If you don't care whether the final returned value is 123, 321, 312, or even just 1 or 2 or 3, then yeah, it does have uses.

    Me, when I concatenate strings I prefer to use code that ensures that all the input is included in the concatenated result - or if I want only some of the input, that I can specify in the WHERE filter exactly what part to include.

    Fair point about the lack of an Order By, I just knocked the code up quickly and forgot that bit.

    But I'm interested in how it could return just 1 or 2 or 3?