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?