Bill, In a message dated 97-09-19 14:29:36 EDT, you write: > I have a physical file with a name field containing mixed case > letters. I would like to use the name as a key field. On my > programs I always provide an input field to position the list. > User's have a difficult time getting the name keyed in the exact > upper/lower case to position the list correctly. What are some ways > to design a logical file or the application to ignore the case and > position the list correctly. I'm not sure that a logical is the answer, although the XLATE op code can be used to translate the characters in RPG. There was a discussion here a year or so ago regarding SOUNDEX implementation on the AS/400 (e.g., key in what the name "sounds like" and get a record back). Anyone still have those old posts? Regards, Dean Asmussen Enterprise Systems Consulting, Inc. Fuquay-Varina, NC USA E-Mail: DAsmussen@AOL.COM "Everywhere is walking distance if you have the time." -- Steven Wright +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to "MIDRANGE-L@midrange.com". | To unsubscribe from this list send email to MAJORDOMO@midrange.com | and specify 'unsubscribe MIDRANGE-L' in the body of your message. | Questions should be directed to the list owner/operator: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.