Search results
Definition and Usage. The REPLACE () function replaces all occurrences of a substring within a string, with a new substring. Note: The search is case-insensitive. Tip: Also look at the STUFF () function.
3 wrz 2024 · Transact-SQL reference for the REPLACE function, which replaces all occurrences of a specified string value with another string value.
This tutorial shows you how to use a very handy string function named SQL REPLACE function to replace all occurrences of a substring with a new one.
In this tutorial, you will learn how to use the SQL Server REPLACE () function to replace all occurrences of a substring by a new substring within a string.
5 mar 2024 · Learn how to manipulate string data in SQL Server using various functions like TRIM, LTRIM, RTRIM, REPLACE, STUFF, CHARINDEX, and TRANSLATE.
24 sty 2022 · The REPLACE SQL function is used to replace a string or substring of a string with another string in a T-SQL script, SELECT statement, UPDATE statement, SQL query or stored procedure in a Microsoft SQL database.
30 sie 2016 · If you want to replace multiple words or characters from a string with a blank string (i.e. wanted to remove characters), use regexp_replace() instead of multiple replace() clauses. SELECT REGEXP_REPLACE("Hello world!123SQL$@#$", "[^\w+ ]", "") The above query will return Hello world123SQL.