How to Replace Sub string in String
- MS Sql Server
- 1854
- March-28-2018
- by Rizwan Saqib
The REPLACE() function replaces all occurrences of a specified string.
Note: The REPLACE() function performs a case-sensitive replacement.
For Example we have a string [First Name] we want to change in [Last Name ] means Replace first into last
SELECT Replace ('FirstName','First','Last') AS ReplaceValue
it Give us Result like this
ReplaceValue |
| Last Name |
