Fixing string data in mssql
Replace function in MSSQL does all the magic. If you want to change the text in a select statement something like this will work:
select replace (url, 'site1.com','site2.com') url from file_data where id = 12307
Alternatively if you want to update the data in table
update file_data set url = replace (url, 'site1.com','site2.com') where id = 12307
The same exact statement works in mysql as well.












