quote:Originally posted by rodmcleay
Im sure there are many situations where the order is not important.
Yes. As long as you are prepared to accept inconsistent output like "A,B,C" on Monday, and "C,A,B" on Tuesday for the same data.
The only reliable way to get consistent output is to use a cursor and ORDER BY <something> to get the (sub) strings in some predictable order.
Custom Apps, Inc.