|Subject||Re: [firebird-support] Blob retreival|
> Firebird 1.5.2 & isql.SUBSTRING does not support blobs. Either wait for Firebird 2, or use UDF.
> Trying to extract a list of all procedures that contain a given string,
> Including the line of the procedure that contains the string.
> I can almost get there but the substring returns null
> select rdb$procedure_name, substring(rdb$description from 1 for 2048)
> from rdb$procedures
> where rdb$procedure_source like '%required_string%';