一个关于sql的问题

[xzyyxiaohao]

我现在有个字段

a
asd222
zxx222
vvv222

怎么样把字段a里面的内容222给去掉那.

[冀章的小目标]

create table test(a varchar(20))
insert test select 'asd222' union all
select 'zxx222' union all
select 'vvv222'
go

select * from test
select substring(a,1,3)[数据] from test

数据     
------ 
asd
zxx
vvv

（所影响的行数为 3 行）

[lgxyz]

DECLARE  @TB TABLE (AA VARCHAR(100))

INSERT INTO @TB SELECT 'asd222' 
UNION ALL SELECT 'zxx222'
UNION ALL SELECT 'vvv222' 

UPDATE @TB SET AA=REPLACE(AA,'222','')
SELECT * FROM @TB

/*AA                                                                                                   
---------------------------------------------------------------------------------------------------- 
asd
zxx
vvv

（所影响的行数为 3 行）
*/

[wuyi8808]

update 表 set a=replace(a,'222','')

[ks_reny]

樓上正解. REPLACE函數.

[水族杰纶]

REPLACE()

[Name]

一二楼的回答都到位啊，

差不多，

接分！！

[conan304]

replace(a,'222','')

[win7cc]

replace

[apple02180503]

[Quote=引用 1 楼 lgxyz 的回复:]
SQL codeDECLARE @TB TABLE (AA VARCHAR(100))

INSERT INTO @TB SELECT 'asd222'
UNION ALL SELECT 'zxx222'
UNION ALL SELECT 'vvv222'

UPDATE @TB SET AA=REPLACE(AA,'222','')
SELECT * FROM @TB

/*AA
---------------------------------------------------------------------------------------------…
[/Quote]
正解

[guxiaoshi]

update TableName set a=replace(a,'222','')

[xzyyxiaohao]

字段要是text 类型怎么办那