title: Set default table value to left pad with zeros
body: <p>How do you create a table where each column will left pad with zeros if the max number of characters are not entered during data entry.<br>
  I know how to pad after the data has been entered into the table but I don't know how to pad during the point of data entry.</p>
  
  <p>example....</p>
  
  <p>import values for a column defined as nvarchar(15)...</p>
  
  <pre><code>RTS092
  3ISUEX
  ABCDEFGHIJ
  9485028
  </code></pre>
  
  <p>stored values in the table after data entry/import....</p>
  
  <pre><code>000000000RTS092
  0000000003ISUEX
  00000ABCDEFGHIJ
  000000009485028
  </code></pre>