title: Is there a way to combine multiple fields in a select query after where?
body: <p>This is the query I'm using in vb.net</p>
  
  <pre><code>select *
  from tbl_patientinfo
  where fname like '%" &amp; txtsearchquery.Text &amp; "%'
      or mname like '%" &amp; txtsearchquery.Text &amp; "%'
      or lname like '%" &amp; txtsearchquery.Text &amp; "%' 
  </code></pre>
  
  <p>I know it's long, and what I want to know is if there is a way to shorten it. I've tried IN, but it doesn't allow multiple columns, only the search variable. Also it doesn't go well with LIKE. I'm looking for a way to make my code look like this:</p>
  
  <pre><code>select *
  from tbl_patientinfo
  where (fname, mname, lname) like '%" txtsearchquery.text "&amp;'
  </code></pre>