Search and Replace function DB2 SQL

A function to replace all occurrences of a string in a source string with a new string.

• Using Db2 REPLACE() function with literal string example

REPLACE(source_string, search_string, replace_string )

SELECT 

    REPLACE('IBM DB2','DB2','Db2') result

FROM 

    sysibm.sysdummy1;

RESULT :  IBM Db2 

• Using Db2 REPLACE() function to Update table data example

UPDATE 

    WEBPAGE

SET 

    Link = REPLACE(Link,'http:','https:')

WHERE 

    Link LIKE '%http:%';

Umar Adil