title: Use Sql LIKE in TableAdapter for int values
body: <p>I want to create my own query with parameters in <code>TableAdapter</code> configuration wizard.</p>
  
  <p>So after this I use this code but it is wrong : </p>
  
  <pre><code>SELECT Name, ProjID
  FROM ProjectTable
  WHERE (ProjID LIKE @ProjID% )
  </code></pre>
  
  <p>because >> syntax error new ')', it is clear .</p>
  
  <p>After some searching, someone with the same problem suggests to use something like this :</p>
  
  <pre><code>SELECT Name, ProjID
  FROM ProjectTable
  WHERE (ProjID LIKE @ProjID + '%')
  </code></pre>
  
  <p>but it is still wrong and give me this error at runtime :</p>
  
  <blockquote>
    <p>Conversion failed when converting the varchar value '%' to data type int.</p>
  </blockquote>
  
  <p>And it is clear too , because I use +'%' in a query that point to a int data type .</p>
  
  <p>So, how can I solve this problem (I mean create a parameter for a query in <code>TableAdapter</code> specially for <code>int</code> data types) ?</p>
  
  <p>Thanks in advance</p>