I need help retrieving compressed data. the data was entered via an
application. the application zipped it and stored it in a blobdata
table. this is what it looks like.

0x5468657265206973206E6F20726573756C7420617661696C61626C6520666F72207468
697320717565727900

does anyone know how to convert this back to text?



Marie M.G. Price p
Database Administrator
Pride IT Support

Waterloo Regional Police Service
200 Maple Grove Rd.
Cambridge, ON N3H 5M1
(519) 650-8500 ext 8739 office
(519) 841-2297 cell
<mailto:marie.[Email address protected] marie.[Email address protected]
<http://www.wrps.on.ca/> http://www.wrps.on.ca

" Alone we can do so little; together we can do so much.....Helen Keller
"

**************************************************************************************************
The contents of this email and any attachments are confidential.
They are intended for the named recipient(s) only.
If you have received this email in error please notify the system manager or the
sender immediately and do not disclose the contents to anyone or make copies.

** eSafe scanned this email for viruses, vandals and malicious content. **
*** PRIDE Police Services ***
**************************************************************************************************

MS Sql Server LazyDBA home page