ALTER  FUNCTION [dbo].[RemoveNonNumeric] (@string VARCHAR(255))  
/* Function coded by Dan Venor @ MMSA - Original idea and implementation for non-numeric Scott Fitzpatrick @ 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
						SET @charstrip = @charstrip + substring(@string, @iCol, 1) + ''
		            END
		END
	RETURN @charstrip
END