title: Stored Procedure to SELECT Last 6 Digits of Number
body: <p>I have a data field in a SQL table with a large number (9 digits, A Customer Information Number). I want to run a stored procedure that will only SELECT the last 6 digits of the number. </p>
  
  <p>Something like:</p>
  
  <pre><code>SELECT (Last 6 Digits of num) FROM db
  WHERE user = @user
  </code></pre>
  
  <p>Does anyone know of a way to accomplish this?</p>