Replace

String Function

Description

Removes all occurrences of a specified substring, and optionally replaces them with another string.

Click here to navigate to the PostgreSQL docs page for this syntax.

The function Replace() is supported on Snowflake.

Grammar Syntax

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

Sample Source Patterns

PostgreSQL

Code

SELECT REPLACE('11223344', '33', 'XX');

Result

1122XX44

Snowflake

Code

SELECT REPLACE('11223344', '33', 'XX');

Result

1122XX44