title: linq to sql wildcard on numeric column
body: <p>In SQL i can do something like this :</p>
  
  <pre><code>select  * from Table1 where Col1 like '%'
  </code></pre>
  
  <p>I'm trying to this in linq like this :</p>
  
  <pre><code>from p in Table1
  where SqlMethods.Like(p.Col1, "%")
  select  new { p.Col1}
  </code></pre>
  
  <p>But it's not working because it's expecting Col1 to be int.</p>
  
  <p>The reason i'm doing this is because i'm trying to build a search form and must use wildcards for the parameters that aren't completed (some are strings, some are numeric).</p>