RemoveNonNumericChars.sql

Create Function [dbo].[RemoveNonNumericCharacters](@Temp VarChar(1000))
Returns BigInt
AS
Begin
	Declare @Return BigInt
    Declare @KeepValues as varchar(50)
    Set @KeepValues = '%[^0-9]%'
    While PatIndex(@KeepValues, @Temp) > 0
        Set @Temp = Stuff(@Temp, PatIndex(@KeepValues, @Temp), 1, '')
		Set @Return = cast(ISNULL(@Temp,'0') as BigInt)
    Return @Return
End