thanks
On Dec 19, 4:56 pm, "khan abuzaid noorulhaque" <[email protected]> wrote: > Hi > > fire query > select * from customer where hobby like %hockey% > > Regards > Abuzaid > > > > On Wed, Dec 17, 2008 at 9:57 AM, 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...- Hide quoted text - > > - Show quoted text -
