title: Insert zero before a numeric datatype in SQL Server
body: <p>I was trying insert a value in a column in SQL Server which is of type <code>numeric(18, 0)</code>.</p>
  
  <p>I am unable to insert a zero at the beginning. For example adding <code>022223</code> gets inserted as <code>22223</code>...</p>
  
  <p>I think changing the column type to <code>varchar</code> will work but I don't want to alter table structure.</p>
  
  <p>Any way to do this without changing the table structure..Please help</p>