【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了实例151去除字符串中非字母和数字的字符.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_num06)iter
where iter.pos<=len(a.n))b
where ascii(b.c) between 48 and 122;
select @i