Remove all Char after Numeric

SELECT SUBSTRING( '10 HIT THE ROAD', 0, LEN(LEFT('10 HIT THE ROAD', PATINDEX('%[A-Z]%', '10 HIT THE ROAD'))))