Re: PL/SQL Question

Bor-Ren Jeng wrote:
> 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?
>
>

Try  

 select title from book_table
 where lower(title) like lower( '%' || :input_title || '%' ) ;

Hope it helps

-- 
Alik Shapiro
Oracle DBA, EDS
The above statements and opinions are my own and do not
necessarily represent those of EDS.