-- Sorting: What a nice problem

Hello all,

In a database I have a char field in which i store my chapter numbers (for a book)

So the fiels are like this:

1.1
1.1.1
1.2
1.6
1.10
2.2

etc...
But When i sort these Chapters I get:

1.1
1.1.1
1.10
1.2
1.6
2.2

So chatper 1.10 is before chapter 1.2?

How can i solve this?

regards and thanks,

Anneke
The Netherlands Received on Fri Apr 09 2004 - 07:27:29 CDT