Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    50

    Unanswered: Ordering results independently of capitalized letter

    Hi!

    When we get some rows from a table (strings) and have them ordered, the results are returned alphabetically ordered but first comes the results with first letter capitalized and then the others. For instance, if we do:

    Code:
     
    SELECT nick FROM User
    ORDER BY nick;
    The results are:

    Ambar
    Claire
    Neo
    Optimosd
    Parlm
    albert
    brain
    navigate
    ...

    How can I have them ordered independently of the first letter being capitalized or not?

    Thanks for your attention!
    Ah! Não ser eu toda a gente e toda a parte!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SELECT UPPER(nick) FROM User
    ORDER BY UPPER(nick);

  3. #3
    Join Date
    Dec 2003
    Posts
    50
    Thanks. I'll use UPPER() just in ORDER BY so it doesn't alter the names!
    Ah! Não ser eu toda a gente e toda a parte!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •