去掉前导0

[ljfblog]

01
002
0003333A
怎么去掉前面的所有0呢？

[老猫五号]

update A
set m = replace(m,'0','')

[唐诗三百首]

create table ljf
(c varchar(15))

insert into ljf
select '01' union all
select '002' union all
select '0003333A'

update ljf
set c=substring(c,
patindex('%[^0]%',c),
len(c)-patindex('%[^0]%',c)+1) 


select * from ljf

c
---------------
1
2
3333A

(3 row(s) affected)

[AcHerat]

update tb
set col = stuff(col,1,patindex('%[^0]%',col)-1,'')
where left(col,1) = 0

[dawugui]

create table tb(col varchar(20))
insert into tb values('01')
insert into tb values('002')
insert into tb values('0003333A')
go

select substring(col , PATINDEX('%[^0]%',col) , len(col)) from tb

drop table tb

/*
                     
-------------------- 
1
2
3333A

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

[勿勿]

create table tb(col varchar(20))
insert into tb values('01')
insert into tb values('002')
insert into tb values('0003333A')
go

update tb
set col = replace(col,'0','')
select * from tb
drop table tb



col
--------------------
1
2
3333A

(3 行受影响)