title: To split numbers using sql server
body: <p>I have a select query I want to split the number into 3 values. Please help me to do this.</p>
  
  <pre><code>SELECT Code FROM Source
  </code></pre>
  
  <pre class="lang-none prettyprint-override"><code>Code
  ----------------
  21859633525935
  </code></pre>
  
  <p>I want to split the <code>Code</code> into 3 values and display in 3 columns using <code>SELECT</code> query, i.e.:</p>
  
  <pre class="lang-none prettyprint-override"><code>First value      Second value     Third value
  --------------------------------------------------- 
  21               85963            3525935
  </code></pre>