title: like search on number column in SQL
body: <p>How do I do a <code>like</code> search on a number column in SQL?</p>
  
  <p>I want numbers which are <code>like '0.0000%'</code>.  </p>
  
  <p>I tried with </p>
  
  <pre><code>select * from emp where emp_id &amp; '' like '123%'
  select * from emp where CONVERT(varchar(20), emp_id) like '123%'
  </code></pre>
  
  <p>but in vain.  </p>
  
  <p>Please help me</p>