【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供097.sql参考,解决您在097.sql学习中工作中的难题,参考学习。
declare @i nvarchar(50);set @i='';
select @i=@i+b.c
from(
select substring(a.n,iter.pos,1) as c
from (select 'as#df*4,56' as n)a ,
(select id as pos from tb_num04)iter
where iter.pos<=len(a.n))b
where ascii(b.c) between 48 and 122;
select @i