ALTER  FUNCTION [dbo].[RemoveNonAlphaNumeric_fn] (@string VARCHAR(255))  
/* Function coded by Dan Venor @ MMSA - Original idea for non-numeric Scott Fitzgerald @ MMSA */
RETURNS VARCHAR(255) 
AS
BEGIN
	DECLARE @charstrip as varchar(30) 
	DECLARE @iCol as integer
	SET @iCol = 0
	SET @charstrip = ''
	WHILE @iCol < len(@string)
		BEGIN
		            SET @iCol = @iCol + 1
		            BEGIN
		                        IF 	(ASCII(substring(@string, @iCol, 1)) >= 48 and ASCII(substring(@string, @iCol, 1)) <= 57) OR
						(ASCII(substring(@string, @iCol, 1)) >= 65 and ASCII(substring(@string, @iCol, 1)) <= 90) OR
						(ASCII(substring(@string, @iCol, 1)) >= 97 and ASCII(substring(@string, @iCol, 1)) <= 122)
						SET @charstrip = @charstrip + substring(@string, @iCol, 1) + ''
		            END
		END
	RETURN @charstrip
END