Skip to content
Home » sql server stuff function

sql server stuff function


SQL STUFF() function is used to delete a sequence of given length of characters from a string and inserting the given sequence of characters from the specified starting index.


STUFF(String, Start, Length, Newstring)

String – It is the string to be modified.

Start  – The starting index from where the given length of characters will be deleted and new sequence of characters will be inserted.

Length -The number of characters to delete from string

 1,472 total views,  5 views today