Try:

SELECT * FROM Catalog WHERE (Catalog.descrip LIKE '%yellow%') AND 
(Catalog.item_type  = 'R').

PS: Only one WHERE should be used regardless.

with regards,
Knut