Replaces all occurrences of search with replace. If you do not specify replace or is an empty string, nothing replaces the string that is removed from str.
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric ...
The REGEXP_REPLACE scalar regular expression function returns a modified source string replaced by a replacement string, where the occurrence of the regular expression pattern found. If no matches are ...