title: How to specify a "Like" on an integer column?
body: <p>This one has me stumped and thought I would pose it to the SO community for help.</p>
  
  <p>A user wants to select all orders that start with a certain ID, example:</p>
  
  <p><em>123</em> would return <em>123</em>, <em>12345</em>, <em>1238790</em>, etc.  ID is an int column however.</p>
  
  <p>I'm using nHibernate and my line currently is:</p>
  
  <pre><code>criteria.Add(Restrictions.Eq("Id", itemId));
  </code></pre>
  
  <p>but that's only going to return me 123.  I can do a Restrictions.Like, but that converts to a SQL LIKE clause and that won't work on an int col.</p>
  
  <p>Any ideas?</p>
  
  <p>EDIT: Sorry, the DB is SQL Server 2008</p>