order question

Results 1 to 2 of 2

Thread: order question

  1. #1
    Join Date
    Dec 1969

    Default order question

    How can I order the recordset based on the result from two colmns? Example: if one column is empty, grab the data from another one, and then order it alphabetically by that result.

  2. #2
    Join Date
    Dec 1969

    Default RE: order question

    Actually the answer is yes but!<BR>Depends if your DB supports this<BR><BR>ORDER BY ISNULL(column1, column2)

Posting Permissions

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