query="select * from product where cat1 like 'Home decoration--%'" this query does not return any tuples in v7.02 but return 1 tuple in v6.5x with the same database population. I ran another query="select * from product where cat1='Home decoration--musical'". This query return one tuple. I ran another query="select * from product where cat1 like '%Home decoration--%'". This query return one tuple.
