Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003

    Unanswered: ORDER BY textfield when textfield may be null

    I'm using an ORDER BY clause to sort the elements of a list box. When the user clicks the heading I want the list box to sort by that column. My only problem is that the null or empty string comes first and then the populated fields in alpha order. Any way to push the empy fields to the bottom of the list? The entire record isn't null just the field on which they are sorting...

  2. #2
    Join Date
    Aug 2003
    Get rid of the null values before loading the list box..

  3. #3
    Join Date
    Sep 2003
    The extremely Royal borough of Kensington, London
    ORDER BY column DESC
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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