Re: a substring question

sanjay rallapally wrote:
>
> 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);

        Use some like this:

	select emp_name
          from employees
         where instr(upper(emp_name),upper(v_address))>0;

Regards

         Konstantin V. Sartakov
                Kuzbassprombank
                       Kemerovo
                         Russia
           mailto:skv_at_kpbank.ru