摘要:
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 阅读全文