>>also i cant cast the blob as a firebird varchar data type because it
>>might be too big for that.
>>
>>
> You can use substring, it converts a blob to varchar
>
> Substring(MyBlob from 1 for 1024)

Yes, but it works only in Firebird 2.

Ivan