title: How do I enable ordinals from the STRING_SPLIT function in MSSQL
body: <p>I'm trying to use the STRING_SPLIT function in Microsoft SQL Server 2019. The function works, if I only put in two arguments, but since I want to extract a specific element from the string, I would like to enable ordinals.
  When I add the third argument to the STRING_SPLIT function it returns</p>
  <blockquote>
  <p>Msg 8144, Level 16, State 3, Line 5 Procedure or function STRING_SPLIT
  has too many arguments specified.</p>
  </blockquote>
  <p>I don't understand what I'm doing wrong, since hovering over the STRING_SPLIT function clearly states that the function can take a third argument as an int.</p>
  <p>My SQL code is as follows</p>
  <pre><code>SELECT *
  FROM STRING_SPLIT('[Control Structure].Root.NP_02.ABC01_02_03.Applications.Prototype.Control Modules.ABC060V.ABC060VXFR2','.',1)
  WHERE ORDINAL = 4
  </code></pre>