title: How to ignore integer start with 0
body: <p>I am working on a web application. I have two text boxes, one is <code>txtEmployeeID</code>, and one is <code>txtEmployeeName</code>. What I am trying to do here is when the user enter <code>EmployeeID</code> in the <code>txtEmployeeID</code>, the name of the employee will show up in the <code>txtEmployeeName</code>. I got this part working so far. However, if the <code>employeeID</code> start with bunch of <code>0</code>, let say <code>00000345</code>, the user need to enter all <code>00000345</code> in the <code>employeeID</code> in order to show that <code>employeeName</code>. I am wondering if there a way for user to just enter <code>345</code> and then that <code>00000345</code>'s <code>employeeName</code> will display in the <code>txtEmployeeName</code>? Help will be appreaciated. </p>
  
  <p>For Example</p>
  
  <pre><code>EmployeeID   EmployeeName
  00000345     James Murray
  </code></pre>
  
  <p>In my text box.</p>
  
  <pre><code>Employee ID: 345   
  </code></pre>
  
  <p>It will display  </p>
  
  <pre><code>Employee Name: James Murray
  </code></pre>
  
  <p>My DB Query</p>
  
  <pre><code>@Employee_ID    varchar(8) = NULL
  
  SELECT s.Employee_ID, p.FIRST_NAME, p.LAST_NAME
      FROM [dbo].[Employee] e INNER JOIN [dbo].[Person] p ON e.PERSON_ID = p.PERSON_ID
      WHERE p.Employee_ID = @Employee_ID
  </code></pre>