Re: Sorting records in a query

It is sorting correctly because those are string values. Numeric values
would be sorted as 1, 2.....10,11,12 etc.

Denis

"reeve13" <reeve13.1y8lhy@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:reeve13.1y8lhy@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> I am having a problem sorting records in a query. I have about 5, 000
> entries in a table and when I build my query based on certain fields,
> the numbers in certain columns are not in order although I use the
> sorting feature. ( e.g.) I have 5 columns with numbering data contained
> in the columns, and I have it set up to sort in ascending order, which
> it did, but I noticed that the Volume # column sorts the Volume numbers
> differently (see example below):
>
> V. 1
> V. 10
> V. 11
> V. 12
> then it goes back to
> V. 2
> V. 3
> V. 4
> V. 5
> V. 6
> V. 7
> V. 8
> V. 9
>
> It looks like it sorts anything with a 1 first then the rest later.
> How do I fix this?
>
> Thanks.
>
>
> --
> reeve13
> ------------------------------------------------------------------------
> reeve13's Profile: http://www.hightechtalks.com/m120
> View this thread: http://www.hightechtalks.com/t2281283
>


.

Relevant Pages

  • general question about how best to cache expensive query results
    ... The question is that when I have a query like: ... entries to those that are newer than a certain date, ... ascending order in order of creation and find the highest id that's at ... as well as dealing with values having different types. ...
    (comp.databases)
  • Sorting records in a query
    ... I am having a problem sorting records in a query. ... entries in a table and when I build my query based on certain fields, ... in the columns, and I have it set up to sort in ascending order, which ... It looks like it sorts anything with a 1 first then the rest later. ...
    (microsoft.public.access.queries)
  • Re: general question about how best to cache expensive query results
    ... The last restriction in the query is the one that is too expensive to ... entries to those that are newer than a certain date, ... ascending order in order of creation and find the highest id that's at ... -- or, more like your original, in case ids might not be ordered ...
    (comp.databases)
  • Re: general question about how best to cache expensive query results
    ... feeds and sometimes don't include the field ... That was my first attempt to limit the entries ... would be the result of that original query. ... presenting the underlying problem and the business requirements. ...
    (comp.databases)
  • Re: Differences in Range Scan Performance between Binary and NLS Indexes
    ... And our query plan looks like this and completes in about 120 ms. ... 400 bytes received via SQL*Net from client ... sorts (memory) ...
    (comp.databases.oracle.server)
Quantcast