title: Search using single input while searching multiple tables
body: <p>I need to make a search button for ASP.NET C# web site. Making a button with 1 kind of search key is easy. For example:</p>
  
  <pre><code>Select * from table where name like '%' + search_criteria + '%'
  </code></pre>
  
  <p>But what I really need is to make a search button that will contain more "like" from different though tables. I have in my DB </p>
  
  <ol>
  <li>Category.Category_Name nchar</li>
  <li>Product.Description nchar</li>
  <li>Product.Product_Cost float</li>
  <li>Manufacturer.Manufacturer_Name nchar</li>
  </ol>
  
  <p>And you can see which ones are in which table. Also with the help of GridView I want to show on my webpage only the first 3. But I want a single textBox with a single button and when I try to search something, search either category name or description or cost or manufaturer name all in 1.</p>
  
  <p>I have read that you can only search multiple things from one table or use contain statement in order to search from different tables. I've looked many hour in internet but in vain. Can someone help me figure out what do I need to right in WHERE clause so I can put that in aspx.cs C# code in LIKE filter and have my button worked?</p>