What is the use of STUFF function in SQL Server 2008?

Select Answer:

It is to insert a string between strings

It is used to overwrite the existing string

It is used to overwrite the existing characters

All of the above