求SQL语句，删指定字符之前的所有内容

update tb set aaa=stuff(aaa,1,charindex('内容',aaa)-1,'')

create table tb(aaa nvarchar(50))
insert into tb select 'askj字符da《bsh字符nkj...内容xzjchbxjkh'
insert into tb select 'jnweuf9per9uhdwf s0489 fasd内容fjp9uisawe'
go
update tb set aaa=stuff(aaa,1,charindex('内容',aaa)-1,'')
select * from tb
/*
aaa
--------------------------------------------------
内容xzjchbxjkh
内容fjp9uisawe

(2 行受影响)

*/
go
drop table tb

update tb set aaa=stuff(aaa,1,charindex('内容',aaa)-1,'')  where charindex('内容',aaa) > 1

update t
set aaa=substring(aaa,charindex(N'内容',aaa),len(aaa))