Subject Re: [firebird-support] Converting A Blob To A String Within A SP
Author Ivan Prenosil
>>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.