Casting...yes, i know. that's what most of you guys will go for....aaand i'll try it but here's what my data looks like:
10
100D
203(A.b)
203(A.c)
340A
399
500
I'm scared that SOME might even have the letter BEFORE the number
obvious way to do this is with (int) type casting
(for those who have the same problem but without the letters, try that)
Is there a better way than this for my data?
FYI the numbers are in MySQL table, if it can be done query-level, let me also.
Thanks,
DM