hello dear
in oracle this query will be
Select * from customer where instr(hobbies,'Hockey',1,1)>0
i m sure it will be done by only instr function.
Just Try It
Ashish
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...
