title: How Do I Split String In SQL Server Based On String Length
body: <p>I want to copy my old data to new DB. i have a address column in my old db with datatype ntext, but in new DB i must use 3 column to put address (address1, address2, address3 with datatype nvarchar(60))</p>
  
  <p>How can i split the string in my OLD DB to my NEW DB?</p>
  
  <p>ex: 
  query from old db : </p>
  
  <pre><code>`select address from client`
  
  result : 
  
  Jl. Taman Crystal 2 Blok TC 2 No.79 RT.001/018, Cluster Crystal Residence, Summarecon Serpong, Pakulonan Barat - Kelapa Dua
  </code></pre>