T-SQL Replace Method

update shows
set ProfileImagePath = replace(ProfileImagePath, '/Content/images/Shows/S', 's')
where Id = 1019