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