|Subject||Re: [firebird-support] Converting A Blob To A String Within A SP|
>>also i cant cast the blob as a firebird varchar data type because itYes, but it works only in Firebird 2.
>>might be too big for that.
> You can use substring, it converts a blob to varchar
> Substring(MyBlob from 1 for 1024)