Sorting dates with NULL values

[Bert de Nooij]

Hi All,

We have a problem with the order of date fields with NULL values.
We are running PH820 with Oracle RDBMS with NULL value support.
In a cluster screen we would like to have a primary file ordered by a date
field in the following order:
  Null values first, existing dates ordered ascending
  but order by ascending or descending does not help us out



Ascending        Descending		What we want
----------------------------------------------------------
2000/12/01       NULL               NULL
2000/12/02       2000/12/31         2000/12/01
2000/12/31       2000/12/02         2000/12/02
NULL             2000/12/01         2000/12/31


Any ideas?


Kindest regards,
Arma bv



Bert de Nooij
Einsteinbaan 4
3439 NJ Nieuwegein
mailto:Bert.DN@Arma.com
http://www.arma.com

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.