Re: -- Sorting: What a nice problem

Anneke

I have written about this problem on my homepage:   http://www.adp-gmbh.ch/ora/misc/sort_chapter/

hth
Rene

> 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

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch