> My problem is the following: I need to use SUBSTR function in a
> Stored Procedure already written inside the database (i.e. not by
> Dynamic SQL).
> Is it possible to call the DECLARE EXTERNAL FUNCTION from inside a
> Stored Procedure?
>
> I don't want to call this statement from the client or via isql.
>
> Is there a way to do this?

If you are using Firebird then you don't need an UDF
for that at all.

For example:

select substring(firstname from 1 for 3) from customer


Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com