title: Remove first two digit and change phonenumber format SQL
body: <p>I have a tableA in which PhoneNumber column have values like 911234567891.
  i want to remove the first two digits from the start i.e 1234567891 and then i want to change it to phone number format xxx-xxx-xxxx so the ending result will be 123-456-7891.
  I have already done it using seprate Select and Update query like this:</p>
  
  <pre><code>SELECT
       [Phone Numbers]
      ,FORMAT([Phone Numbers],'###-###-####') AS [Formatted Phone]
      FROM tbl_sample
  
  
  UPDATE tbl_sample
  SET    [Phone Numbers] = SUBSTRING([Phone Numbers], 3, 8000) 
  WHERE [Phone Numbers] LIKE '91%'
  </code></pre>
  
  <p>Is it possible to do it using single select query only so that there will be no need to update the data first?
  Any kind of help or suggestion will be appreciated. </p>