• Lynn Pettis (5/4/2016)


    It removes ONLY the first comma (,) leaving all the other commas in the comma separated list.

    I must remember to engage brain before commenting - I was thinking of only one Value per AccountNumber, so there was no comma separated list. That "ORDER BY Value" clause makes it pretty obvious that more than one value can be handled for an AccountNumber, so there may be comma separated lists.

    Tom