We have soundex in our project, and we comes to now few things:- {Your questions - answer (1)} 1. It will work only on characterset of the oracle you have chooseen 'English' or 'french' etc. 1st word 'for' in english 2nd word 'par' in french -> Not Match -> But words meaning are smiliar 2. If only works only smiliar sounds. 1st word 'Amit' 2nd word 'aMit' -> Match 3. If you change the sequence it doesnt work:- 1st word 'Amit Verma' 2nd word 'Verma, AMit' -> Not Match On Fri, Apr 25, 2008 at 1:43 PM, LegeDoos <legedoos@xxxxxxxxx> wrote: > Hello, > > The Oracle soundex function is in English language. Are there also > soundex functions for other languages? > > Regards, > > Rob > -- > //www.freelists.org/webpage/oracle-l > > > -- Amit Verma Oracle DBA & System Adminstrator E-Mail:- in.amitverma@xxxxxxxxx, v.amit@xxxxxxxxxxx WebSite:- http://www.linkedin.com/in/vamit IM:- verma.labs@xxxxxxxxx Mobile:- (+91) 98910.98927