SQL Soundex

This will be used to find words that sound like other words, exclusively used in where clause.

    Syntax: soundex (string)

    Ex:

         SQL> select * from emp where soundex(ename) = soundex('SMIT');

     EMPNO ENAME      JOB            MGR HIREDATE         SAL     DEPTNO

     --------  --------            -----             -----    ------------         --------- ----------

      7369    SMITH      CLERK         7902   17-DEC-80        500         20