How can you update part of the value in SQL?

I have this sample:

I wanted to change the value of & # 39; && # 39; in & # 39; C: & # 39; having problems composing a script.
enter the description of the image here