you're breaking normalization rules. in particular you have multiple values in the hobbies field.
hobbies should be in its own table with CustID as the foreign key. select * from tablename where hobbies like %hockey%; 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... -- Charles A. Lopez [email protected] Bachelor of Arts - Computer Science New York University Registered Microsoft Partner New York City, NY
