Re: Help with Soundex code..

dgadhiwa@thunder.ocis.temple.edu (Dharmesh Gadhiwala) wrote: > >Hi friends, > >I am looking for the Informix code written for Soundex example. >I know it exists, b'caz someone saw it 3 yrs back on internet. >can someone help me with this. I don't remember that, but you can look at http://jg.cso.uiuc.edu/pg/vol-overview.html It has a form to submit stuff. As an example, Anderson is A536 The Soundex system is the means established by the National Archives to index the U.S. censuses (beginning with 1880). It codes together surnames of the same and similar sounds but of variant spellings. Soundexes are arranged by state, Soundex code of the surname, and given name. Soundex codes begin with the first letter of the surname followed by a three-digit code that represents the (first three) remaining consonants. Let the Soundex converter do the tricky work for you and capture the nuances of the coding scheme (such as coding adjacent like letters as one). Enter above the surname that you want coded. Soundex Coding Guide 1 = B,P,F,V 2 = C,S,G,J,K,Q,X,Z 3 = D,T 4 = L 5 = M,N 6 = R The letters A,E,I,O,U,Y,H, and W are not coded. Note that surname prefixes such as van, Von, Di, de, le, D', dela, or du are sometimes disregarded in alphabetizing and in coding. Dan Anderson, dan@bluebird.com, +1-619-438-2220 x354 (FAX +1-619-438-4560) Bluebird Systems, 5900 La Place Court, Carlsbad, CA 92008-8806, USA