ORDER BY.... (n.n.n.n....)

admin

Administrator
Staff member
I have a table with articles with a number (like 1, 1.1, 1.1.1, 1.1.2, 1.2 and so on... 100.1, 10.2.3 and stuff...).

The field of the number is VARCHAR(25) 'cause otherwise I can't use

DOING A SELECT * .... ORDER BY number

I get this order

1
10
100
2
20
200
3
...

But I want
1
2
3
10
20
30
100
200
...

How can I solve this problem?
 
Back
Top