Getting XML data

[Ryan]

We have a proc that returns some xml using FOR XML EXPLICIT. When i get this value out of the DB is is in an unreadable format (Binary, Unicode or something else). How can I extract the XML text?

[Ikar]

SDAC represents XML in the same form as obtained from the server. We cannot suggest any method of analysing of received result.