PRElias/Split_string_as_table.sql

Last active September 12, 2018 18:48

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/PRElias/c3536a95a9902daa66f14f188807cfb7.js"></script>
Save PRElias/c3536a95a9902daa66f14f188807cfb7 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

Split_string_as_table.sql

	SELECT
	value
	,REPLACE(REPLACE(value, CHAR(13), ''), CHAR(10), '') AS OnlyCharacters
	FROM STRING_SPLIT(
	'paulo
	,roberto
	,elias
	', ',')

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment