i have records such as
1.1
1.2
1.3
.......
1.10
1.11
1.12
etc
when I do an order by on these fields they are sorted like
1.1
1.10
1.11
1.12
1.2
- they are stored as text, and need to be - but is there a way i can convert them to an int or decimal in the SQL order by clause?
ive tried
ORDER BY CONVERT(INT, process_id)
ORDER BY INT(process_id)
but that doesnt work
any ideas?!
