Reading XML stored as BLOB datatype in SQL Server DB table

Hi,

Any one attempted reading a BLOB from DB - SQL Server ?

I am having a requirement to read a BLOB from SQL Server Table wherein BLOB contains a XML.

The issue I am having is finding a query to convert the BLOB to Xml
If query works then can just read the BLOB as xml

I tried converting the BLOB Column content using CAST
ex Select CAST(CAST(BLOB AS VARCHAR(MAX)) AS XML) from Table ;

but not successful.

OR
If there is a java API/jar that be directly used to parse BLOB as XML ??

Thanks