MSSQL某字段某些内容替换

Question

MSSQL某字段某些内容替换例如表  S_ORDER   ,  字段   NAME
                           AAA咀asdfasd
                           咀aaaa
                           qwerqw咀asdfasdf
要求替换后结果如下: (把字段中包含有"咀"字的全部替换成"嘴",但是其它内容不变)                          AAA嘴asdfasd
                           嘴aaaa
                           qwerqw嘴asdfasdf
          

Answer 1

UPDATE TB SET COL=REPLACE(COL,'咀','嘴')

Answer 2

update tb set NAME=replcae(Name,'咀','嘴')

Answer 3

update tb set col=raplace(col,'咀','嘴')

Answer 4

update S_ORDER set NAME=REPLACE(NAME,'咀','嘴')

Answer 5

update S_ORDER set NAME=replcae(NAME,'咀','嘴')

Answer 6

update S_ORDER set name = replace(name , '咀' , '嘴')