sunraajkumar

 Profile Answers by sunraajkumar Questions by sunraajkumar

• Jul 1st, 2009

 

Soundex function is used to find the phonetic representation of string

Syntax
----------

Soundex(CHAR)

Query
--------

SELECT Empname FROM Employee WHERE SOUNDEX(EMPNAME)=SOUNDEX('SMYTHE')

sure_prince

 Profile Answers by sure_prince Questions by sure_prince

• Aug 14th, 2009

 

This is Soundex Function is useful to select the data according to the sound of
the given value but not compare with the casing of that letters.

For Example:

SQL> SELECT * FROM emp WHERE Soundex(Ename)=Soundex('Analyst');

It select all the Analyst details in emp table in anuy case...