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