>> > You can use substring, it converts a blob to varchar
>> >
>> > Substring(MyBlob from 1 for 1024)
>>
>>Yes, but it works only in Firebird 2.
>
> Works here on Firebird 1.5.2, Ivan. :-))

Ahaa, I tried it with RDB$PROCEDURES.RDB$PROCEDURE_SOURCE
since it is sub_type 1, and it does not work on FB1.5.2, it does work on FB2.
Probaly bug caused by unicode_fss.
For "normal" blobs it indeed works even with FB1.5, thanks Helen.

Ivan