select (Field+'7,8,9') as Field from tablename select replace(field,'2','') as field from tablename
update tablename set field= field+'7,8,9'
去掉一个字符可能用一句不能实现我(只用SQL语句的话),但是可以这样: select f1,f2,f3,replace(field,'2','') as f4 into temptb from tablename where 条件 update temptb set f4=f4+'7,8,9' where 条件 update tablename set field=temptb.f4 from temptb where tablename.f1=temptb.f1 drop temptb
select replace(field,'2','') as field from tablename
select f1,f2,f3,replace(field,'2','') as f4 into temptb from tablename where 条件
update temptb set f4=f4+'7,8,9' where 条件
update tablename set field=temptb.f4 from temptb where tablename.f1=temptb.f1
drop temptb