Cadavre,

I'm getting the following error when executing the following SQL:

SELECT ParamValues.XMLProfile_TXT.value('.','VARCHAR(MAX)') AS DID

FROM Payment_Method_T (nolock)

OUTER APPLY XMLProfile_TXT.nodes('/div/ul/li/did') ParamValues(XMLProfile_TXT);

Msg 9506, Level 16, State 1, Line 1

The XMLDT method 'nodes' can only be invoked on columns of type xml.

Can you let me know what I'm doing wrong? Also, is this whole string required (e.g. '/div/ul/li/did')? I only want /DID tag only. What is the other chars for?

Thanks,

David