Skip to content

Instantly share code, notes, and snippets.

@codenamejason

codenamejason/RemoveNonAlphaChars.sql

Created January 2, 2018 17:12
Show Gist options
  • Save codenamejason/fa6f55895f84689e9e8da2797fedc690 to your computer and use it in GitHub Desktop.
Save codenamejason/fa6f55895f84689e9e8da2797fedc690 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
RemoveNonAlphaChars.sql
CREATE FUNCTION [dbo].[RemoveNonAlphaCharacters](@Temp VarChar(2000))
RETURNS VARCHAR(2000)
AS
BEGIN
DECLARE @KeepValues AS VARCHAR(50)
SET @KeepValues = '%[^a-z]%'
WHILE PatIndex(@KeepValues, @Temp) > 0
SET @Temp = Stuff(@Temp, PatIndex(@KeepValues, @Temp), 1, '')
RETURN @Temp
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment