order by a XML column

Hi,

I have a table with a varchar column which store XML in this format :

<A>Value of A</A><B>Value of B</B><C>Value of C</C>

How can I sort the result by this column and the content of one of the tag.

e.g. The table has 2 rows :
row 1: <A>Man</A><B>Woman</B><C>Child</C> row 2: <A>Tree</A><B>Flower</B></C>Plant</C>

If I sort by the tag "<B>", the result would be : row 2
row 1

If I sort by the tag "<A>", the result would be : row 1
row 2

Thanks & Regards,
Chris Received on Thu Mar 14 2002 - 05:45:33 CET