Try the below script
declare @str varchar(1000),
@word varchar(100),
@newword varchar(100)
select @str = 'He is a positive influence on other students',
@word = 'He',
@newword = 'ABC'
select @str Old, stuff(@str, charindex(@word, @str), len(@word), @newword) new