title: How I can get the first 3 digits in 123456 Numbers in sql?
body: <p>I have field called <strong>CallingParty</strong> in My CDR table it contains data like this:</p>
  <pre><code>CallingParty
  ------------
  267672668788
  </code></pre>
  <p>I want to select the first 3 number of each of those numbers like</p>
  <pre><code>CallingParty
  ------------
  267
  </code></pre>