截取字符串。。。。。

[Landa_Jimmy]

SELECT '000000001250003182' AS ID UNION ALL
SELECT '0000DT0002' UNION ALL
SELECT '0001298989' 

如何把前面的0截取掉？？

[卖水果的net]

-- 写一个自定义函数吧

drop function fn_trim
go
create function fn_trim(@str varchar(max), @ch varchar(1))
returns varchar(max)
AS
begin
while @str like @ch + '%' 
begin
set @str = substring(@str,2,len(@str))
end
return @str 
end 
go

with m as (
SELECT '000000001250003182' AS ID UNION ALL
SELECT '0000DT0002' UNION ALL
SELECT '0001298989' 
)
select id , dbo.fn_trim(id,'0') from m 
go

id                 
------------------ ------------------------------
000000001250003182 1250003182
0000DT0002         DT0002
0001298989         1298989

(3 行受影响)

[薛定谔的DBA]

SELECT ID,REPLACE(LTRIM(REPLACE(ID,0,' ')),' ',0)
FROM(
	SELECT '000000001250003182' AS ID UNION ALL
	SELECT '0000DT0002' UNION ALL
	SELECT '0001298989' 
)TAB

[满天飞雪No1]

SELECT '000000001250003182' AS ID into #table UNION ALL SELECT '0000DT0002' UNION ALL SELECT '0001298989' select * from #table select case when ISNUMERIC(ID)=1 then cast(CAST(id as bigint) as varchar(50)) else substring(id,patindex('%[A-Z]%',ID),50) end,* from #table

[中国风]

WITH T1
AS
(
SELECT '000000001250003182' AS ID UNION ALL
SELECT '0000DT0002' UNION ALL
SELECT '0001298989' UNION ALL
SELECT '1234' )
SELECT ID=STUFF(ID,1,PATINDEX('%[^0]%',ID)-1,'') FROM T1

[BiChangQing]

又学了一招.....