title: How to split string with delimiter and get the first value
body: <p>I have the following query where I have a table which is storing from information with a delimiter</p>
  <p>SQL version - Microsoft SQL Azure (RTM) - 12.0.2000.8</p>
  <pre><code>DECLARE @commanTable TABLE
  (
    CommaId NVARCHAR(MAX),
    Name NVARCHAR(500)
  )
  
  DECLARE @commanTable1 TABLE
  (
     CommaId INT,
     Name NVARCHAR(500)
  )
  
  INSERT INTO @commanTable VALUES ('2324205.3933251.7336404', 'Test1'), 
  ('2324206.3933252.7336405', 'Test2')
  
  INSERT INTO @commanTable1 (CommaId, Name)
  SELECT  value, Name
  FROM   @commanTable CROSS APPLY STRING_SPLIT(CommaId,'.');
  
  SELECT * FROM @commanTable1
  </code></pre>
  <p>Getting the following results</p>
  <p><a href="https://i.stack.imgur.com/TxfrM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TxfrM.png" alt="enter image description here" /></a></p>
  <p>Where I need the results to be</p>
  <p><a href="https://i.stack.imgur.com/NYSfV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NYSfV.png" alt="enter image description here" /></a></p>