column with xml data to be sorted?

Apr 28 2011 2:14 AM

I have a column with 10 rows. Each row has xml datas of many rows.

when i sort it , i get the following error.

The xml data type cannot be compared or sorted, except when using the IS NULL operator.
Warning: The join order has been enforced because a local join hint is used.

How to sortcolumn with xml data.