On Tue, Aug 31, 2010 at 2:50 PM, Kent Belan <[email protected]> wrote: > I think the problem is that you are trying to sort numeric data in a > character field. > > You can create a new index like > Index on padl(invno,10,'0') tag invsort > > Then you should get the sort you are looking for -----------------
Why not sort on DtoS(invoice date) + invoice # -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
