|
Hi Angela, On the AS400 you could simply create a logical file the ALTSEQ(QSYS/QASCII) file-level keyword and all your key fields will be sorted as if they were ASCII encoded. Then your sales department can still use 0-9 or even lowercase a-z in their sort field and it will sort the same as the SQL server. hth, Peter Dow Dow Software Services, Inc. 909 425-0194 voice 909 425-0196 fax From: "Angela Wawrzaszek" <awawrzaszek@nucorauburn.com> > We will have to look at recoding our 2 position text field. Once they cme > up with the plan I can do the mass change for them. We do not use all 26 > X26 right now. We would not be able to change the field to 3 positions as > this is a software package, not a home grown application or file. _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.