declare @I INT ,@y int
declare @str1 varchar(50),@str2 varchar(50),@number varchar(50),@string varchar(50)
set @str1='一个4人的4朝2圣230'
set @str2=@str1
set @number=''
set @string=''
set @i=0
--while 循环
while @I<len(@str2)
begin
set @i=@i+1
--case (str as int)字符串转换整数类型
--ascii(s) 0-9 返回为48-57 字符串或字母都大于57
set @y= cast(ascii(substring(@str2,@i,len(@str2))) as int)
--判断是否为字符串
if(@y>57)
set @string=@string+substring(@str1,@i,1)
else
set @number=@number+substring(@str1,@i,1)
end
print '==============结果============='
print ''
print 'string:'+@string+' number:'+@number