> Firebird 1.5.2 & isql.
>
> 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%';

SUBSTRING does not support blobs. Either wait for Firebird 2, or use UDF.

Ivan