Using STRING_SPLIT

Using STRING_SPLIT.

Last updated: 13 October 2016

Warning: Review and test in a non-production environment before running.

Back to results

-- SQL SERVER 2016

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

value
-----
Lorem
ipsum
dolor
sit
amet.