Just one point to make here : Wildcard characters have the potential to be specific to the Database provider. For instance, MS Access uses the the "*" character while most others use the "%" character to match multiple characters. Since the OP hasn't bothered to tell us what database she is using, I just wanted to clarify this pitfall.
On Dec 18, 7:15 pm, "aleti neetha" <[email protected]> wrote: > 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...- Hide quoted text - > > - Show quoted text -
