If the column name is called TYPE then add to your WHERE clause in the SELECT statement:

WHERE TYPE NOT LIKE '%[0-9]%'

If the column has blank values you may want to use

WHERE TYPE NOT LIKE '%[0-9]%'
AND TYPE <> ''

The LIKE clause will ignore all rows where the TYPE column as a numeric value anywhere within it.