> I'm working on the migration of a FB1.5 database to FB2.1.
> In my FB1.5 database i used an udf "trim", but in fb2.1 trim is an FB internal
> function.

Note to all, for future reference, do not use UDF names which *could* conflict with internal functions that may be added. For myself, to ensure maximum safety, I always add a "F_" prefix to UDF names.

> I want to use the internal function and remove the udf.

You would need to follow the following steps.

1- In the source database, define a new "F_Trim" UDF which uses the same entry point as the exists "trim" UDF.
2- In the source database, replace all "trim" references with "F_Trim" in procedures and triggers. (If you extract db metadata to script/text file, you can perform search/replace -- just remember to also replace "CREATE PROCEDURE" and "CREATE TRIGGER" with "CREATE OR ALTER PROCEDURE" and "CREATE OR ALTER TRIGGER")
3- In the source database, drop "Trim" UDF
4- Backup source and restore to new database
5- (Optional) In the new database, replace all "F_Trim" references with "Trim" in procedures and triggers.


Sean