title: How can I determine if a field has leading zeroes in SQL Server 2008 R2?
body: <p>I have a varchar field on a table and I need to know if there is a way to know if it starts with a given number of zeroes.</p>
  
  <p>Do I have to use variables or if-else?</p>