摘要: create function dbo.GetNumber(@Num varchar(32))returns varchar(32)asbegindeclare @i intwhile patindex('%[a-Z]%',@Num) > 0beginset @i = patindex('%[a-Z]%',@Num)set @Num = stuff(@Num,@i,1,'')endset @Num = replace(@Num,' ','')return @NumendCreate Function GetA 阅读全文
posted @ 2011-11-23 22:57 (二少)在南极 阅读(235) 评论(0) 推荐(0) 编辑