SELECT * FROM 485713_cms.tblProducts where coastal = 'NO' AND trim(proCountry) LIKE '%Oregon' order by proname asc Portfolio