how to replace the selected characters with custom text

to replace the selected characters with custom text using sql server,
use the following sql query

SELECT REPLACE ('BLABLA IS A TEST!','IS','was')

return value : BLABLA was A TEST!