Re: Phonetic Search

Christophe Laloo <laloo_at_delight.be> wrote:

>Hello,
>
>To search on a table phonetically I want to write a soundex-function.
>Is there somebody who can give me the source of a soundex-function?
>It should be applicable for all European languages.

Why write one when it already exists?

SELECT name

	FROM emp
	WHERE SOUNDEX(name)  = SOUNDEX('ERIC')