DataTamer: SQL Server Services

Remove all Special Characters

The following code will strip all special characters from text.

DECLARE @CustomLabel nvarchar(200) = 'Comma 78 , Star * Num # tilde ^'
WHILE PATINDEX('%[^A-Za-z0-9]%', @CustomLabel) > 0
	BEGIN
	SET @CustomLabel = STUFF(@CustomLabel, PATINDEX('%[^A-Za-z0-9]%', @CustomLabel), 1, '')
	END
SELECT @CustomLabel

Code

© All rights reserved. DataTamer Inc. 2012