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