I have a third-part DB wherein the designers store raw RTF (Rich Text) in a BLOB field. I need to extract the raw RTF text from this. So I have tried CAST(MyField as VARCHAR(32000)), but the resultant field is also considered a BLOB field, so this did me no good. How can I extract the raw text of the BLOB field?
So I guess this question may be better phrased as how to cast bit data as text.
Thank you. I get the distinct impression that this cannot be done in SQL because DB2 SQL does not have any native operators or functions to deal with this conversion. I can probably do it in VB, which is my development platform.