Αποτελέσματα Αναζήτησης
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 Ιαν 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.
25 Ιουλ 2012 · SELECT cast(fname as char(25)) + ' ' + cast(lname as char(25)) from (select replace(replace(LEFT(MLIS.REQUESTOR_FIRST_NAME, CharIndex(' ', MLIS.REQUESTOR_FIRST_NAME + ' ' ) - 1 ), ',MD', ''), ', MD', '') as fname, replace(relpace(left(MLIS.REQUESTOR_LAST_NAME, CharIndex(',', MLIS.REQUESTOR_LAST_NAME + ',' ) - 1), CharIndex(',', LEFT(MLIS ...
24 Ιαν 2022 · In this article we look at the SQL Server REPLACE function and show several examples of how this can be used to replace text values in strings.
5 Μαρ 2024 · Learn how to manipulate string data in SQL Server using various functions like TRIM, LTRIM, RTRIM, REPLACE, STUFF, CHARINDEX, and TRANSLATE.
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. Syntax
27 Νοε 2018 · In this article, I’ll show you how to find and replace data within strings. I will demonstrate how to use the function SQL REPLACE, where you look for a substring within a string, and then replace it. This article answers the following commonly asked questions: What does the SQL replace function do in SQL Server?
