title: SQL remove text, leave number
body: <p>I have some old data in an access database that is very poorly formated. There is a packSize column with mixed data. Sometimes it says "2 pack", sometimes "4 pk", sometimes "3", etc. What I would like to do is run an SQL command to remove all the text and leave just the number. How should I go about this? </p>