Thanks Vijay,
This is helpful to know.
Im sure there are many situations where the order is not important.
Rod

======================================
"They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad."
--Shakespeare
======================================

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.

Jeff Mason
Custom Apps, Inc.
[email protected]