Re: Soundex in Informix, how?

jlumbley@netcom.com (Joe Lumbley) wrote: :Abdu (abdu@agora.rdrop.com) wrote: :: I would like to use a soundex like function where I want to a get a set :: of rows that based on a string (column) which is similar or close to a :: desired string. :: Something like: :: select name from terms from name = "FAQ" :: I would to get back names like "FAQ", "PHAQ", "FAK", "PHAK", "FAC", etc... :: Abdu :Try www.iiug.org. They have some soundex routines in the archives. Yes, but soundex will not give you the desired results. It relys on the first character beeing the same. I think there is a metaphone algorithm as well in the FAQ that will do this. Nils.Myklebust@idg.no <- New E-mail adress NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company