CODE EXAMPLE FOR SQL

String split in sql server

SELECT [Value] FROM STRING_SPLIT('Lorem ipsum dolor sit amet.', ' ');