Labels

Wednesday, July 24, 2013

SQL UDF to Remove Special Characters from Text



CREATE FUNCTION [dbo].[fn_RemoveSpecialCharacters] (@name VARCHAR(max))
RETURNS NVARCHAR(max)
AS
BEGIN
       DECLARE @str VARCHAR(MAx)

       SET @str = @name

       WHILE PATINDEX('%[ !@#$%^&*()<>?:"{},./;=+|\_]%', @str) > 0
              SET @str = REPLACE(@str, SUBSTRING(@str, PATINDEX('%[ !@#$%^&*()<>?:"{},./;=+|\_]%', @str), 1), '')

       RETURN replace(@str, '-', '')
END


No comments:

Post a Comment