Re: Oracle 9i LIKE search assistance

trpost_at_gmail.com wrote:
> I am looking to be able to search a VARCHAR column in a table for a
> search string; Here is an example:
>
> Table: cases
>
> description
> -----------------
> airport bla bla bla
> bla bla bla airport
> bla airport bla bla
>
>
> SELECT description FROM cases WHERE description LIKE '%airport%'
>
> The problem is this only returns 1 result:
> bla airport bla bla

You didn't actually try it did you.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org