REPLACE

Applies to

• SQL Server

• Azure Synapse Analytics

Description

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

Sample Source Pattern

Syntax

SQL Server

REPLACE ( string_expression , string_pattern , string_replacement )  

Snowflake SQL

Snowflake SQL complete documentation

REPLACE( <subject> , <pattern> [ , <replacement> ] )

JavaScript

String.replace( pattern, new_expression)

Examples

SQL Server

Code:

IN -> SQLServer_01.sql

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

Output:

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

Snowflake SQL

Code:

OUT -> SQLServer_01.sql

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

Output:

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

JavaScript

Code:

CREATE OR REPLACE FUNCTION REPLACER (str varchar, pattern varchar, new_expression varchar)
  RETURNS string
  LANGUAGE JAVASCRIPT
AS
$$
   return STR.replace( PATTERN, NEW_EXPRESSION );
$$;

SELECT REPLACER('Real computer software', 'software', 'science') AS COLUMNNAME;

Output:

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

Known Issues

No issues were found.

Related EWIs

No related EWIs.