STUFF function In SQL

Posted By : Bipul Kumar Tiwari,

The STUFF function inserts a string into another string. It deletes a specified length of characters in the first string at the start position and then inserts the second string into the first string at the start position.

Syntax:


               STUFF( Source_String, Start, Length, ReplaceWith_string )

where:

Source_String :The source string to modify. It can be a constant, variable, or column of either character or binary data.

Start : Is an integer value that specifies the location to start deletion and insertion .

Length : Is an integer that specifies the number of characters to delete.

ReplaceWith_string : The sequence of characters to insert into the source_string at the start position. It can be a constant, variable, or column of either character or binary data.




Related Articles

 

About the Author

author
Its me BIPUL who is logically minded creative at heart , a good communicator , a self taught full stack developer. I constantly focuses on my thinking , reading , collecting and creating my work in a order to enhance my skills.

I discover new dimensions for growing bussiness with a proven record in creating database and programming. I have a strong technical skills as well as strong interpersonal skills. Read more...
 

Browse By Category

Popular Articles