Re: a substring question

sanjay rallapally wrote:

> 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) ?

How about:

select emp_name from employees

       where upper(emp_name) LIKE
 '%'||upper(v_address)||'%';

Mark W. Received on Thu May 29 1997 - 00:00:00 CDT