Hi Karen, this is why I work with SET ZERO ON,
give it a try J Fritz Von: [email protected] [mailto:[email protected]] Im Auftrag von Karen Tellef Gesendet: Dienstag, 17. Dezember 2013 01:44 An: RBASE-L Mailing List Betreff: [RBASE-L] - Sorting conundrum Using 9.5, 32-bit I'm putting up a data browser, and it is sorting by a currency column DESCENDING. Many of these rows will have nulls in that column. Sorting in Descending order puts the nulls at the top of the list; I'd rather they went at the bottom. I can probably screw around with adding another column to this temp table, assigning a dummy huge negative number to force the sorting, but I'm wondering if there's a "set" command or something that would help me on this. Karen
