REGEXP_REPLACE Function - SQL Server Documentation

Last Updated: 2023-10-26

Syntax

                
                    REGEXP_REPLACE (
                        expression, pattern, replacement, [position]
                    )

Description

The REGEXP_REPLACE function replaces occurrences of a regular expression pattern in a string with a specified replacement string.

This function is part of the SERVERPAST extension. You must enable the extension before using this function.

Learn more about Regular Expressions in SQL Server

Parameters

expression: The string that you want to modify.
pattern: The regular expression pattern to search for.
replacement: The string that replaces the matched pattern.
[position]: (Optional) The zero-based position in the expression to start the search from. If omitted, the search starts from the beginning of the string.

Example

                
                    SELECT REGEXP_REPLACE('My phone number is 123-456-7890', '[0-9]+', 'XXX', 1);
                    -- Result: My phone number is XXX-XXX-XXXX