[TYPO3] mysql ordering

[Lübke Pedderson]

Hi all,
I have some mysql problem.

When I call records from DB and say "ORDER BY NUMBER"
It gives me the number field always in order like

1
10
100
101


But how can I make the order like

1
2
3
4
5
6
7
8
9
10
11
etc...

The field has the value INTEGER (11)

What am i missing?

Lübke