title: How to split the string in one column into two columns
body: <p>I have a table like this</p>
  
  <pre><code>id          value
  -------     ---------------
  1           ind.kolkatta
  2           ind.pune
  3           ind.mumbai
  4           pak.lahore
  5           pak.karachi
  6           uae.sharjah
  </code></pre>
  
  <p>I want to return the following table:</p>
  
  <pre><code>id          contry       place
  -------     ---------    ----------
  1           ind          kolkatta
  2           ind          pune
  3           ind          mumbai
  4           pak          lahore
  5           pak          karachi
  6           uae          sharjah
  </code></pre>
  
  <p>how can i do that using MSSQL.? I have already done in MYSQL using SUBSTRING_INDEX function</p>
  
  <p>My MySql query</p>
  
  <pre><code>SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(`value`, '.', 1), '.', -1) as contry,
         SUBSTRING_INDEX(SUBSTRING_INDEX(`value`, '.', 2), '.', -1) as place 
  FROM   `table`
  </code></pre>