Hey,neetha ,
Your select statement partially work,It will check for
only statements start with 'hock' ,
not for statements contains 'hock'..I think you got the difference...
On Dec 17, 7:12 pm, "aleti neetha" <[email protected]> wrote:
> Hi,
>
> For this, please try once below select stmt.
>
> select * from customer where hobbies like 'hock%'
>
> Thanks,
> Neetha.
>
> On Tue, Dec 16, 2008 at 11:27 PM, Priyanka <[email protected]> wrote:
>
> > CUSTOMER
>
> > CustID FName LName Hobbies
> > 1 Fred Smith Fishing, Rollerball, Hockey
> > 2 Sally Jones Sailing
> > 3 Brian Wilson Gliding, Sailing, Singing, Hockey
>
> > now from this table i wanted to findout the customer whose hobby is
> > 'Hockey' without changing the table becoz my orginal table is too
> > complicated to change the schema..
> > plz suggest the query...
