Calling a UDF with UPDATE

From InterBase
Jump to: navigation, search

In UPDATE statements, a UDF can be used in the SET clause as part of the expression assigning column values. For example, the following statement uses TRIM() to ensure that update values do not contain leading or trailing blanks:

UPDATE COUNTRIES
SET COUNTRY = TRIM (2, ' ', COUNTRY);