Use of Soundex Function

Hi Friends,

I have a field member_name in member_master.dbf
it has few records e.g.
SHAIKH SABA WASEEM
ANSARI JAVID AHMED
NARIWALE ASRAR
SHAIKH EJAZ AHMED
SHAIKH LUQMAN AB. AZIZ
KHAN IJAZ AHMED

When i browse for ;
BROWSE FOR $"EJAZ" MEMBER_NAME
it returns
SHAIKH EJAZ AHMED

but i want to use soundex function or any other function to return
both records matching with EJAZ, IJAZ, AEJAZ etc.

e.g.
SHAIKH EJAZ AHMED
KHAN IJAZ AHMED

Thanks in advance

Anders
Wed Mar 05 06:56:03 CST 2008

Soundex is difficult to apply where you're searching for a part only of the
full name. Try:
SELECT * FROM xx WHERE name like '%JAZ%'
or
SELECT * FROM xx WHERE name like '%J_Z%'

which will return names that contain EJAZ, IJAZ or AEJAZ, and IJEZ, AJOZ, or
EJUZ if they are variant spellings.

-Anders

"intel4" <ansari.javid@gmail.com> wrote in message
news:6d024887-15e9-4f06-90aa-abf5d4accb47@h11g2000prf.googlegroups.com...
> Hi Friends,
>
> I have a field member_name in member_master.dbf
> it has few records e.g.
> SHAIKH SABA WASEEM
> ANSARI JAVID AHMED
> NARIWALE ASRAR
> SHAIKH EJAZ AHMED
> SHAIKH LUQMAN AB. AZIZ
> KHAN IJAZ AHMED
>
> When i browse for ;
> BROWSE FOR $"EJAZ" MEMBER_NAME
> it returns
> SHAIKH EJAZ AHMED
>
> but i want to use soundex function or any other function to return
> both records matching with EJAZ, IJAZ, AEJAZ etc.
>
> e.g.
> SHAIKH EJAZ AHMED
> KHAN IJAZ AHMED
>
> Thanks in advance

Willianto
Tue Mar 11 16:15:47 CDT 2008

intel4:

I'll second Anders'. Continuing his suggestion, I suggest you get the
requested criteria (like 'JEZ' or 'JAZ'), chrtrans all vowels into an
underscore ('J_Z' or 'J_Z'), add wild cards ('%J_Z%' or '%J_Z%'), and then
put it in the where clause of your select statement with LIKE operator.

hth,
Willianto

RandyBosma
Wed Mar 12 13:26:14 CDT 2008

Hello Intel4,

One point to remember: Soundex is a phonetic algorithm for indexing names by
sound, as pronounced in English. If the names you are searching for have non-
english this tool will not work very well for you. See
http://en.wikipedia.org/wiki/Soundex for a decent explantion of the algorithm.
do a Google search on 'Soundex' and you'll find thousands of pages that
discuss the concept.

HTH,
Randy
_________________________
intel4 wrote:
>Hi Friends,
>
>I have a field member_name in member_master.dbf
>it has few records e.g.
>SHAIKH SABA WASEEM
>ANSARI JAVID AHMED
>NARIWALE ASRAR
>SHAIKH EJAZ AHMED
>SHAIKH LUQMAN AB. AZIZ
>KHAN IJAZ AHMED
>
>When i browse for ;
>BROWSE FOR $"EJAZ" MEMBER_NAME
>it returns
>SHAIKH EJAZ AHMED
>
>but i want to use soundex function or any other function to return
>both records matching with EJAZ, IJAZ, AEJAZ etc.
>
>e.g.
>SHAIKH EJAZ AHMED
>KHAN IJAZ AHMED
>
>Thanks in advance

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/foxpro-general/200803/1