一个简单的sql语句

Question

asdfsdf/www.163.com/urlerdsgghhffgt
asdfsdf/www.163.com/urlerdsfdfdffgt
dfdfdf/www.163.com/urlerdsdfdfffgt
asdwewewewefsdf/www.163.com/urlerdswwewewffgt
把这些中的www.163.com都 改成www.sohu.com用sql语句怎么写啊 

Answer 1

replace(field,'www.163.com','www.sohu.com')

Answer 2

declare @str varchar(8000)
set @str='asdfsdf/www.163.com/urlerdsgghhffgt'
select replace(@str,'www.163.com','www.sohu.com')

Answer 3

select replace(field,'www.163.com','www.sohu.com')

Answer 4

终结:
update 表 set field=replace(field,'163','sohu')