What is SOUNDEX function?

 Posted by Niladri.Biswas on 4/29/2013 | Category: Sql Server Interview questions | Views: 1167 | Points: 40
Answer:

It compares the field values that sounds like the supplied input word.
SQL> Select * From tblPlayers
2 Where Soundex(BELONGSTO) = Soundex('Lindia');


PLAYERID PLAYERFIRS PLAYERLAST BELONGSTO DOB FEEPERMATCH
---------- ---------- ---------- ---------- --------- -----------
11 P Chopra India 14-FEB-98
1 A Raman India 20-DEC-84 2000
2 B Kadir India 01-JAN-80 1000
3 C Nadir India 21-APR-00 3000
4 D Das India 11-NOV-80 500
5 E Punchkar India 14-FEB-80 12000
6 rows selected.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response