Saturday, June 22, 2013

Get Numeric values From AlphaNumeric String

create function dbo.getnumericfromalphanumeric
(
@alphanumeric varchar(8000)
)
returns varchar(8000)
as
begin
declare @replacementpossition int
set @replacementpossition=(select patindex('%[^0-9]%',@alphanumeric))
while (@replacementpossition>0)
begin
set @alphanumeric=(select stuff(@alphanumeric,@replacementpossition,1,''))
set @replacementpossition=(select patindex('%[^0-9]%',@alphanumeric))
end
return @alphanumeric
end


--select dbo.getnumericfromalphanumeric('ABCD123XYZ456')

No comments:

Post a Comment