1
Answer

column with xml data to be sorted?

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.
Answers (1)