Select
   'TRIGGER' as TIPO,
   T.RDB$TRIGGER_NAME as NOME,
   T.RDB$TRIGGER_SOURCE as CODIGO
from RDB$TRIGGERS T
where
   upper(T.RDB$TRIGGER_SOURCE) like '%' || :TEXTO || '%'

union all

Select
   'PROCEDURE' as TIPO,
   P.RDB$PROCEDURE_NAME as NOME,
   P.RDB$PROCEDURE_SOURCE as CODIGO
from RDB$PROCEDURES P
where
   upper(P.RDB$PROCEDURE_SOURCE) like '%' || :TEXTO || '%'