Stuff function and replace function

Stuff function
Delete a specified length of characters and insert another set of characters at a specified starting point.
Syntax:

STUFF (String, startingposition, LengthofReplaceChar, ReplaceString)
Example:

Declare @fname Varchar(100)

Declare @lname Varchar(100)

declare @result varchar(50)

SET @fname = 'rohatash'

SET @lname = 'kumar '

 

SET @result  =  STUFF(@fname, 3,7, @lname )

 

Print 'Result: ' + @result

Replace function
Replace all occurrences of the second given string expression in the first string expression with a third expression.
Syntax:
REPLACE (String, StringToReplace,StringTobeReplaced)
Example:

Declare @fname Varchar(100)

Declare @lname Varchar(100)

declare @result varchar(50)

declare @replacestring varchar(30)

SET @fname = 'rohatash'

SET @lname = 'ro'

set @replacestring ='ku'

 

SET @result  =  replace(@fname, @lname ,@replacestring)

 

Print 'Result: ' + @result

OUTPUT: