title: How to search about a specific value in all columns in the table?
body: <p>I have a table (<code>students_all</code>) that contains 4 columns as below :-</p>
  
  <ul>
  <li>student_name</li>
  <li>age</li>
  <li>student_id</li>
  <li>class </li>
  </ul>
  
  <p>Now how can I search about a specific value such as <code>'left'</code> in all columns in one query using <strong>SQL Server 2008</strong>.</p>
  
  <p>I mean how can make something like Excel (<kbd>Ctrl</kbd>+<kbd>F</kbd>) to find any value in all columns.</p>