1,建序数表 select top 8000 identity(int,1,1) as N into numtab from (select top 100 id=1 from sysobjects) as a, (select top 100 id=1 from sysobjects) as b, (select top 100 id=1 from sysobjects) as c-------------------------------------------------------------- select * from numtabdeclare @str varchar(100) set @str='中国a10b123cc'select *,substring(a.strnum,b.N,1) strbit from (select @str as strNum)a left join numtab b on charindex(substring(a.strnum,b.N,1),a.strnum,n)=b.n where ASCII(substring(a.strnum,b.N,1))>128 自己改成自定义函数就行了.
1,建序数表
select top 8000 identity(int,1,1) as N into numtab from
(select top 100 id=1 from sysobjects) as a,
(select top 100 id=1 from sysobjects) as b,
(select top 100 id=1 from sysobjects) as c--------------------------------------------------------------
select * from numtabdeclare @str varchar(100)
set @str='中国a10b123cc'select *,substring(a.strnum,b.N,1) strbit from
(select @str as strNum)a left join numtab b on
charindex(substring(a.strnum,b.N,1),a.strnum,n)=b.n
where ASCII(substring(a.strnum,b.N,1))>128
自己改成自定义函数就行了.