Subject RE: [firebird-support] Declare External Function and Stored Procedure
Author Thomas Steinmaurer
> 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