I had tried doing a SET EQNULL ON to see if it behaved differently but it didn't. In an ASC sort nulls go to the bottom, but a DESC sort nulls go to the top (obviously then).
No big deal, I can create a view with a "union" to get it done. Karen -----Original Message----- From: MikeB <[email protected]> To: karentellef <[email protected]> Sent: Thu, Oct 29, 2015 1:31 pm Subject: [RBASE-L] - RE: Descending sort Null is not a value. Even if you substitute its representation, it is still NULL, so it's not going to sort. > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Karen > Tellef > Sent: Thursday, October 29, 2015 1:52 PM > To: [email protected] > Subject: [RBASE-L] - Descending sort > > Just want to make sure there isn't an easy setting that I'm missing... > > I have a listbox that sorts by SaleDate DESC. However, the rows with a > blank SaleDate are at the top. We'd like them to be at the bottom. So > rather than constructing a view that would do that for me, is there > some kind of setting that would force nulls to be at the bottom of a > DESC list? > > Thanks!! > > Karen
