Skip to content
Home » SQL Server STUFF Function By Practical Examples

SQL Server STUFF Function By Practical Examples

SQL STUFF

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.

Syntax

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

Loading