title: Error converting data type varchar to bigint
body: <p>When i use this string as a sql command-string compiler gives me no error:</p>
  
  <pre><code>string sql = "SELECT * FROM Students WHERE StudentNo='" + T_No.Text + "'";
  </code></pre>
  
  <p>But, if i use this string (includes '%' character) it says "<strong>Error converting data type varchar to bigint</strong>":</p>
  
  <pre><code>string sql = "SELECT * FROM Students WHERE StudentNo='%" + T_No.Text + "%'";
  </code></pre>
  
  <p>What should i change in order to use '%' in my statement?</p>