Search results
2 gru 2016 · MySQL has a CASE statement. The following works in SQL Server: CASE MyColumnName. WHEN 1 THEN 'First' WHEN 2 THEN 'Second' WHEN 3 THEN 'Third' ELSE 'Other'
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.
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.
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.
The SQL REPLACE() function is used to search for a specified substring within a string and replace it with another substring. This function is useful for cleaning or modifying data by replacing characters, words, or symbols with desired values.
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.
5 mar 2024 · Learn how to manipulate string data in SQL Server using various functions like TRIM, LTRIM, RTRIM, REPLACE, STUFF, CHARINDEX, and TRANSLATE.