how to ammend custom text in a selected position in sql server

to ammend custom text in a selected position in sql server,
use the following sql query

SELECT STUFF ('BLABLA IS A TEST', 8, 2, 'replaced')

return value : BLABLA replaced A TEST