title: Add "-" to varchar value in SQL Server
body: <p>I have a <code>TELEPHONE_NUMBER</code> as a <code>varchar</code> like this:</p>
  
  <pre><code>Value : "1112223344"
  </code></pre>
  
  <p>And I need to add "-" to the value like this:</p>
  
  <pre><code>111-222-33-44
  </code></pre>
  
  <p>So how can I add <code>-</code> to my telephone number value in my SQL Server stored procedure?</p>
  
  <pre><code>CREATE PROCEDURE SP_TELEPHONE_NUMBER
     (@TELEPHONE_NUMBER VARCHAR(4000))
  AS
  BEGIN
     INSERT INTO DOSYA_ARSIV(TELEPHONE_NUMBER)
     VALUES(@TELEPHONE_NUMBER)
  END
  </code></pre>