Transact SQL - String Split - Jack and Jill

TransactSQLStringSplitJackAndJill.sql

declare @rhyme          varchar(8000)
declare @CHAR_SEPARATOR char(1)

set @rhyme 
    = 'Jack and Gill went up the hill '
      + 'To fetch a pail of water '
      + 'Jack fell down and broke his crown '
      + 'And Gill came tumbling after.'

set @CHAR_SEPARATOR = ' '

SELECT  
          itvfSS.ordinal

        , itvfSS.[value]

FROM   STRING_SPLIT

        (
              @rhyme
            , @CHAR_SEPARATOR
            , 1
        ) itvfSS

order by

    itvfSS.ordinal asc

;