Re: a substring question

[This followup was posted to comp.databases.oracle.misc and a copy was sent to the cited author.]

In article <Pine.A41.3.95q.970526141407.417448A- 100000_at_sp2n09.missouri.edu>, c696346_at_showme.missouri.edu says...
> 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);

Look at the INSTR function.

--rick Received on Mon May 26 1997 - 00:00:00 CDT