How to query to get value of xml element when shown as below.
I have this in an xml doc . I can query and get any value successfully however this returns a null every-time, does this require special handling while querying XML.
I have tried OpenXml and node() function everything returns NULL...
]', 'float') Price --RETURNS NULL
<ListPrice Type="FLOAT" CurrencyCode="USD">139900.00</ListPrice>