Search results
3 wrz 2024 · Transact-SQL reference for the REPLACE function, which replaces all occurrences of a specified string value with another string value.
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.
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.
24 sty 2022 · Learn how to use the REPLACE function in T-SQL to replace a string or substring with another string in a SQL database. See syntax, parameters, examples and tips for working with collations, numeric values and multiple replacements.
20 paź 2016 · SELECT Replace(Postcode, ' ', '') AS P FROM Contacts WHERE Replace(Postcode, ' ', '') LIKE 'NW101%' or you can make it a subquery. select P from ( SELECT Replace(Postcode, ' ', '') AS P FROM Contacts ) t WHERE P LIKE 'NW101%'
27 lis 2018 · Learn how to use the SQL REPLACE function to find and replace data within strings in SQL Server. See syntax, examples, collation, multiple patterns, updates and use-case scenarios.
12 kwi 2024 · In SQL Server, the REPLACE () function is used to modify a string value. It is used to replace all the occurrences of a substring with a given string. We generally use the REPLACE () function along with the SELECT statement or UPDATE statement. It is also a case insensitive.