Searching statement by using combobox

Two columns Product_Code and Description in a table in mssql database

Product_Code     Description
P001                 Premier Coffee Mix
P002                 GoldRost Coffee Mix
P003                 White Coffee

 

I want to search Product_code or Description alternatively by typing in combobox,
the result will display Product_code

How to search Product_Code by Description with not all same words, by searching like words by using sql query statement?