why are you using the wildcard for specific columns to be returned? I would use something like the following:
select fname,lname where hobby like 'hoc%' This is of course assuming that you are using MS SQL or MS Access. As Charles mentioned earlier you are going against the rules of normalization, but if you use your current schema, this should work. On Fri, Dec 19, 2008 at 7:01 AM, CK <[email protected]> wrote: > > that won't work. > > On 18 Dec, 12:56, Amit Baranwal <[email protected]> wrote: >> Better u try with this: >> >> select * from Front_Desk where Hobbies='Hockey' >> >> hopefully it will work fine >> >> On Dec 17, 9:27 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 -
