Convert blob to string

[teknogeek9]

MS SQL SERVER 2005
CR XI R2

I have an RTF field that is an (image,null) field in the database. I am able to display the contents of the field in CR using the following SQL Expression:
//%Notes
{fn substring(BEHOLD_Tasks.TASK_RTF_NOTES,0,100000000)}

This field displays in hexdecimal. Is there a CR function that will convert a hex to its proper string or does anyone have any suggestions?

Thanks in advance!

 

[kray4660]

I do not know of a direct way. I think I have seen formulas that will convert hex to whatever you need. If you indeed are converting hex to a string (characters), then I think that would be long and complicated.

 

[chelseatech]

If it is an RTF file, have you tried using the Text Interpretation option. A field can be interpreted as HTML or RTF.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm