REPLACE

Description

Replaces all occurrences of a specified string value with another string value. (REPLACE in Transact-SQL).

Sample Source Pattern

Syntax

REPLACE ( string_expression , string_pattern , string_replacement )  

Examples

Code:

SELECT REPLACE('Real computer software', 'software','science') AS COLUMNNAME

Output:

COLUMNNAME           |
---------------------+
Real computer science|

Last updated