TD SWE

TD SWE

  • 1.3k
  • 321
  • 6.8k

Searching statement by using combobox

Dec 2 2012 10:37 PM
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?

Answers (1)