a substring question

hello again,

how do i search for a string in a larger string ? please don't tell me to use substr 'cuz i tried that eg:
  224, Lewis Hall

User input:
 lewis

SQL statement:
 select emp_name from employees

      where substr( upper(emp_name),1) LIKE upper(v_address);

where v_address contains lewis
Can anyone point out my mistake and/or a better way to search for a string( in this case 'lewis') in a larger string( 224, Lewis Hall) ?

Sanjay Rallapally
c696346_at_showme.missouri.edu
1205, Univ. Ave, #236,
Columbia, MO65201
(573)874-8720 Received on Mon May 26 1997 - 00:00:00 CDT