I've tried to help this person but I don't do much with blobs

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%';

--
Nick
-----We Solve your Computer Problems---
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly