The column that was returned from the nodes() method cannot be converted to the data type %1!s!. It can only be used with ...

The column that was returned from the nodes() method cannot be converted to the data type %1!s!. It can only be used with one of the four XML data type methods, exist(), nodes(), query(), and value(), or in IS NULL and IS NOT NULL checks.