Skip to content

Instantly share code, notes, and snippets.

@codenamejason
Created January 2, 2018 17:13
Show Gist options
  • Save codenamejason/34465b4920c08aca2c70426c17cec67b to your computer and use it in GitHub Desktop.
Save codenamejason/34465b4920c08aca2c70426c17cec67b to your computer and use it in GitHub Desktop.
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment