Use of replace

恶魔右指

declare @sql varchar (1000)
set @sql = '<Cmd> MAReport </ Cmd>'
select stuff (@ sql, charindex ('<Cmd>', @ sql) + len ('<Cmd>'), charindex ('</ Cmd>', @ sql)-(len ('<Cmd>') + 1), 'Chinese')-the character to be replaced here

------------------------------
<Cmd> Chinese </ Cmd>

(The number of rows affected is 1 row)