Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: -- Sorting: What a nice problem

Re: -- Sorting: What a nice problem

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 11 Apr 2004 19:15:43 GMT
Message-ID: <c5c5gv$3cgd$1@ID-82536.news.uni-berlin.de>

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
Received on Sun Apr 11 2004 - 14:15:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US