title: How to insert leading zero in SQL Server
body: <p>This is the code for selecting with leading zeros:</p>
  
  <pre><code>SELECT RIGHT('00000'+ CONVERT(VARCHAR,Asset_No),6) 
    FROM schemaAsset.SystemDefined
  </code></pre>
  
  <p>How can I insert a value to the column Asset_no with leading zeros?</p>
  
  <p>Example is I am only inserting "1" to the column Asset_no, but in the code, it will insert "000001". And also when I insert two digits like 26, it will insert as "000026". The length does not change. Is this possible in SQL Server?</p>