SQL-soundex function

set serveroutput on;
set headsep !;
ttitle 'Employee Information ' ;
btitle 'From Sarat Chand';
set linesize 5000;
set pagesize 10;
set newpage 0;

select * from employees where employee_id in(100,101,102,201,202,103);

Neena
select * from employees where soundex(last_name)=soundex('King');