SQL Tutorial Home

How to replace a Substring in a String

MS-SQL Server provides the following string replacement function:

select replace(fruit_name,'ap','AP') as fruit_name from fruits;