Hi All,

Can anyone tell me how to i convert blob fields to varchars in a
select statement? I use select statements to export data from firebird
to text files but whenever i export a table that contains a blob field
the text file just has a blank space where the blob field should be.

Is there a specific command i can use to extract a certain amount of
characters from the field in my select.

Thanks in advance,
Phil