Use
Replace[
^]
UPDATE TableName SET ColumnName = (SELECT REPLACE(ColumnName,'E:/BackUpWebsites/sri','') FROM TableName)
You can update by the following way
UPDATE TableName SET [ColumnName] = REPLACE([ColumnName],'E:/BackUpWebsites/sri','') FROM TableName
Acknowledgment - Thanks to Ankur.