Re: How do you use *HIVAL and *LOVAL?????

["David Morris" <dmorris@xxxxxxxxxxxxx>]

Phil,

If last name is a separate field, in most cases I would use a soundex 
algorithm.  It converts names to a shortened representation based on 
the sound of the name.  You store the shortened representation in the 
file and convert a search value entered to the shortened representation.  
You then use those values to perform the search/position.  It cuts through 
a lot of easily misspelled names.  You should be able to find more 
information about this on the web.  I also have an RPG sub-procedure 
that returns a soundex representation for a value.

David Morris

>>> "Phil & Vera Hayes" <PHayes1@Prodigy.net> 11/08/99 06:51AM >>>
Hello,
My Next assignment requires a generic search for customer's Last Name.

Would I use *HIVAL and *LOVAL, and it so, how do I incorporate it?

I have learned much from all of you in this form, and your help would be
greatly appreciated.
Thank You
Phil

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---