soundex function

[Abdulrauf]

Hello,

Is there any way I can compare a name column in one table to a column in
another table using the soundex function.

I want to loop through the names in one table and compare them with similar
sounding names in the second table.

Thank you,
Rohith

[Jacco Schalkwijk]

SELECT table1.<column_list> , table2.<column_list>
FROM table1
INNER JOIN table2
ON SOUNDEX(table1.name) = SOUNDEX(table2.name)

--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.


"Abdulrauf" <rshetty@amideast.org> wrote in message
news:Om4$PyKQDHA.2160@TK2MSFTNGP11.phx.gbl...

> Hello,
>
> Is there any way I can compare a name column in one table to a column in
> another table using the soundex function.
>
> I want to loop through the names in one table and compare them with

similar

> sounding names in the second table.
>
> Thank you,
> Rohith
>
>

[arthur benedetti white]

has anybody already developed a server side soundex
function?

[Wim Hollebrandse]

Basic SoundEx algorithms are not that difficult to implement yourself.

For a good example, check out the following link:

[url]http://www.codeproject.com/csharp/soundex.asp[/url]

Hope that helps,
Wim Hollebrandse
[url]http://www.wimdows.com[/url]
[url]http://www.wimdows.net[/url]

"arthur benedetti white" <adbenedettiwhite@bpa.gov> wrote in message
news:02f801c34c95$7a7daac0$a301280a@phx.gbl...

> has anybody already developed a server side soundex
> function?

[Arthur Benedetti White]

I want to be able to include a soundex function in my
asp.net pages do compare values users enter in a phonebook
against the actual data in Active Directory (AD).

we used to use sql server, but the source data has now
moved from sql server to AD where there is not a native
soundex function.

-Arthur.

>-----Original Message-----
>Hi,
>
>I have developed both server side and client side soundex
>implementation in one of my old project. If you can
>elaborate your requiremrnts I can help you.
>
>There is inbuilt Soundex function in SQL server. If you
>are looking for spell check implementation based on
>soundex you can refer the MS word dictionary too....
>
>Let me know if you need furtehr ehlp.
>
>regards
>Sreejumon[MVP]
>

>>-----Original Message-----
>>has anybody already developed a server side soundex
>>function?
>>.
>>

>.
>

[Wim Hollebrandse]

Populate the data from Active Directory (with a certain applied filter) and
then perform your own custom SoundEx (see link I sent in previous reply) on
that.

HTH,
Wim Hollebrandse
[url]http://www.wimdows.com[/url]
[url]http://www.wimdows.net[/url]

"Arthur Benedetti White" <adbenedettiwhite@bpa.gov> wrote in message
news:036c01c34ca2$93670100$a401280a@phx.gbl...

> I want to be able to include a soundex function in my
> asp.net pages do compare values users enter in a phonebook
> against the actual data in Active Directory (AD).
>
> we used to use sql server, but the source data has now
> moved from sql server to AD where there is not a native
> soundex function.
>
> -Arthur.

> >-----Original Message-----
> >Hi,
> >
> >I have developed both server side and client side soundex
> >implementation in one of my old project. If you can
> >elaborate your requiremrnts I can help you.
> >
> >There is inbuilt Soundex function in SQL server. If you
> >are looking for spell check implementation based on
> >soundex you can refer the MS word dictionary too....
> >
> >Let me know if you need furtehr ehlp.
> >
> >regards
> >Sreejumon[MVP]
> >

> >>-----Original Message-----
> >>has anybody already developed a server side soundex
> >>function?
> >>.
> >>

> >.
> >