Articles → SQL SERVER → stuff and replace functions in SQL server

stuff and replace functions in SQL server

Software requirement

Prerequisite knowledge

Replace function

Click to Enlarge

SELECT REPLACE('This is the original string','is','was')

Stuff function

select stuff('This is the original string',6,2,'was')

Click to Enlarge

select stuff('hello',6,2,'how are you')

select stuff('hello ',6,2,'how are you')

Posted By  -  Karan Gupta
Posted On  -  Sunday, January 06, 2013


Your Email Id  
Query/FeedbackCharacters remaining 250