Report question

Question: Convert partially non-numeric text into number in MySQL query