求能实现这样功能的 SQL 语句，多谢！

[「已注销」]

老师布置的作业

数据库名字：data
数据库内有一个表，名字为：biao
里面有字段：ziduan1,ziduan2

ziduan1,ziduan2 放的都是nvarchar格式的字符串

要求实现的功能是：

求出ziduan1内所有以“ school@ ”开头的记录，并把这个记录的ziduan2内的记录都加上字符串“xyz”做为新记录写在ziduan2内

例如：

ziduan1内有如下数据

id ziduan1 ziduan2

1 abc yuxi
2 [e-mail] haha
3 jsuehgja haha
4 school@pieadf haha
5 school@fufufuf haha



执行sql语句后应该是这样的结果

id ziduan1 ziduan2

1 abc yuxi
2 [e-mail] hahaxyz
3 jsuehgja haha
4 school@pieadf hahaxyz
5 school@fufufuf hahaxyz





多谢各位！！！！！！

[zheninchangjiang]

参考charindex函数

[xiaomeixiang]

select id,ziduan1,(case when charindex('school@',ziduan1 )=1 then ziduan2+'xyz' else ziduan2 end)as ziduan2 from biao

[paoluo]

Select id,ziduan1,( Case When CharIndex('@',ziduan1)>0 Then ziduan2+'xyz' ELse ziduan2 End )As ziduan2 from biao

[wyb0026]

select id,ziduan1,case when left(ziduan2,7)='school@' then ziduan2+'zyz' else ziduan2 end from biao

[wyb0026]

不好意思字段写错了
select id,ziduan1,case when left(ziduan1,7)='school@' then ziduan2+'xyz' else ziduan2 end from biao

[点点星灯]

declare @a table(id int,ziduan1 varchar(50),ziduan2 varchar(50))
insert @a(id,ziduan1,ziduan2)
values(1,'abc','yuxi')
insert @a(id,ziduan1,ziduan2)
values(2,'[e-mail]','haha')
insert @a(id,ziduan1,ziduan2)
values(3,'jsuehgja','haha')
insert @a(id,ziduan1,ziduan2)
values(4,'school@pieadf','haha')
insert @a(id,ziduan1,ziduan2)
values(5,'school@fufufuf','haha')


select * from @a
select id from @a where ziduan1 like 'school@%'
update @a set ziduan2=ziduan2+'xyz' where id in
(select id from @a where ziduan1 like 'school@%')

select * from @a

[「已注销」]

多谢各位，试验去了！！！！

[点点星灯]

大家的速度好快啊!!

[remote_peng]

select id,ziduan1,(case when ziduan2 like 'school@%' then ziduan2+'zyz' else ziduan2 end ) As ziduan2 from biao