STUFF Function in SQL Server

STUFF function is used to replace a string with another string within a text. This function can be very helpful in some situation.

Here you can see the syntax of this function along with the example:

Syntax:

STUFF ( character_expression1 ,   start ,   length , character_expression2 )

Example:

Output:

SQL DATABASE is USEFUL

You may also like...