Re: PL/SQL Question

David J Roth wrote:
>
> Bor-Ren Jeng wrote:
> >
> > Hi folks,
> >
> > I am new in the oracle world. I have a very simple question in the sql.
> >
> > I have a column is the title of books in a table . Now
> > if I want to select all the record has the "food" in the title field(e.g
> > Italien Food, Chinese Food or .....). What I try is:
> >
> > select title from book_table
> > where title like '%:input_title%';
> >
> > The :input_title is a varable which is input from a input box in a form.
> >
> > What this query returned is the title = 'food' not the title like '%food%'
> > Do I miss something here?
> >
> > Thank you for your help!
> >
> > -------------------------------------------------
> > | <<Bor-Ren Jeng>> |
> > | E-mail: borren_at_gwis2.circ.gwu.edu |
> > | URL=http://gwis2.circ.gwu.edu/~borren |
> > | George Washington University (703)415-1308 |
> > -------------------------------------------------
>
> Try: where upper(title) like upper('%'||:input_title||'%');

If I were you, I will user TEXT SERVER or Context Option.

ben Received on Tue Oct 08 1996 - 00:00:00 CEST