string_split in sql server 2016 code example Example: sql server 2016 split string SELECT value FROM STRING_SPLIT('Lorem ipsum dolor sit amet.', ' ');