Convert BOD message to varchar

jarat

Hi All, How to convert BOD from varbinary to nvarchar or xml from table ION_BOD_MESSAGE?

I try to use the command as below but I got the Chinese character not xml.

SELECT CONVERT(nvarchar(max), C_BOD) FROM ION_BOD_MESSAGE WHERE C_ID = 603839

Please advice how to get it.

I need to get the approval user from Acknowledge Workflow BOD.

Thank you very much.

Jarat. 

 

BradleyBrown

CAST(C_XML as xml)