Essential Books

Split

suggest change

Splits a string expression using a character separator. Note that STRING_SPLIT() is a table-valued function. 

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

Result: 

value
-----
Lorem
ipsum
dolor
sit
amet.
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

String Functions:
*String Functions
*Concatenate
*Length
*Trim empty spaces
*Upper lower case
*Split
*Replace
*Stuff
*Substring
*REGEXP
*LEFT - RIGHT
*REVERSE
*REPLICATE
*Replace function in sql Select and Update query
*PARSENAME
*INSTR
Table Of Contents