Skip to content

Instantly share code, notes, and snippets.

@codenamejason

codenamejason/RemoveSpecialChars.sql

Created January 2, 2018 17:13
Show Gist options
  • Save codenamejason/9a36ee6a3c4cdc80dfaf3ef44011575c to your computer and use it in GitHub Desktop.
Save codenamejason/9a36ee6a3c4cdc80dfaf3ef44011575c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
RemoveSpecialChars.sql
CREATE FUNCTION [dbo].[RemoveSpecialCharacters](@Temp VarChar(2000))
RETURNS VARCHAR(2000)
AS
BEGIN
DECLARE @KeepValues AS VARCHAR(50)
SET @KeepValues = '%[^A-Za-z0-9]%'
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