Order By Problems

Results 1 to 3 of 3

Thread: Order By Problems

  1. #1
    shawn. Guest

    Default Order By Problems

    Hi all,<BR><BR>Currently, I have a lot of old data used for pick lists that were originally entered into the db using a variety of formats (i.e first letter capital, all caps, all lower case, etc.). When I use a select statement to grab the pick lists, they come back ordered in a way that all the words starting with caps return first (A to Z) then all words starting with lower case letters are returned (a to z). The Order By statement works fine with SQL Server, but in the production environment I am using Oracle 8i as the back end db. How can I get around this problem? Is making sure all the data is entered uniformly the only solution? Thanks!<BR>

  2. #2
    jamar Guest

    Default RE: Order By Problems

    i don&#039;t know the name of the oracle function to do this but:<BR><BR>select picklist_name from picklist<BR>order by lower(picklist_name) desc

  3. #3
    shawn. Guest

    Default RE: Order By Problems

    Hi Jamar,<BR><BR>Your suggestion worked! Thanks a bunch for your help.<BR><BR>

Posting Permissions

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