1257406
1244370
14629850
14571912
14703617
1127118
1279864
12830047
14834633
12514780
14675897
1605564
1380825
14287142
14777157
11088396
12895978
14098193
14639272
14156977
我要一条语句把前面的1去掉怎么去啊,
1244370
14629850
14571912
14703617
1127118
1279864
12830047
14834633
12514780
14675897
1605564
1380825
14287142
14777157
11088396
12895978
14098193
14639272
14156977
我要一条语句把前面的1去掉怎么去啊,
select stuff([字段],1,1,'') from tb
select (case when left(col,1) = '1' then stuff(col,1,1,'') else col end)col
from tb
--全部是1的话
select right(2,len(col)) from tb
create table t1
(
id int
)
insert into t1
select 1257406 union all
select 1244370 union all
select 14629850 union all
select 14571912 union all
select 14703617select right(id,len(id)-1) as id from t1