Description:
STUFF function is used to append number of characters from one string and replace them with another string. So, you can say this function insert string into another string, it removes all the specified length of string and insert other string value on that place.
Syntax
STUFF(string, start, length, add_string)
Example:
1- SELECT STUFF('dotnetguru.in',12,2, 'com') as [stuff eg]
2- SELECT STUFF('www.dotnetguru.in',1, 0, 'http://') as [stuff eg]
Output:
1- dotnetguru.com
2- http://www.dotnetguru.in
0 comments:
Post a Comment