Calling a UDF with UPDATE

Go Up to Calling a UDF

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);