CREATE FUNCTION RemoveNonNumericChars(@inputString NVARCHAR(255)) RETURNS NVARCHAR(255) BEGIN DECLARE @outputString NVARCHAR(255) = ''; DECLARE @i INT = 1; DECLARE @currentChar NVARCHAR(1);

WHILE @i <= LEN(@inputString) BEGIN
    SET @currentChar = SUBSTRING(@inputString, @i, 1);
    
    IF @currentChar BETWEEN '0' AND '9' OR @currentChar = ' ' BEGIN
        SET @outputString = @outputString + @currentChar;
    END IF;
    
    SET @i = @i + 1;
END;

RETURN @outputString;

END;