title: Performing a LIKE comparison on an INT field
body: <p>I'm fairly new to SQL and I was trying to get a full list of products that match a user input of a productID. Something like:</p>
  
  <pre><code>SELECT ProductID, ProductName FROM Products WHERE ProductID LIKE '%15%'
  </code></pre>
  
  <p>I would like it to list out all the matching products such as:
  15, 150, 2154, etc</p>
  
  <p>Unfortunately I'm running into problems because the productID field is an INT and not a string. Is there some relatively simple way around this?</p>