sql server split string by delimiter get fist part code example

Example: sql server 2016 split string

SELECT value FROM STRING_SPLIT('Lorem ipsum dolor sit amet.', ' ');