Hi Sreenivas, I have given '%' after hock , this '%' means it takes after hock whatever we give.
Thanks, Neetha. On Thu, Dec 18, 2008 at 2:46 AM, Sreenivas <[email protected]>wrote: > > 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... >
