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|

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|

PreviousQUOTENAME in JS NextREPLICATE

Last updated 3 years ago

Was this helpful?

hashtagDescription

hashtagSample Source Pattern

hashtagSyntax

hashtagExamples

Description

Sample Source Pattern

Syntax

Examples