INT(TRIM(LEFT("[FIELD]", 4) ) )
This is the closest I've got so far.
Some fields had a range in them.. Like 1546.00-2923.00
Others 0.00, others 1513.00
I'm guessing at some point in the 30+ million rows there's some text...
What can I do without messing with the source database?