Nov 2, 2015 · I don't believe SQL Server has a built-in split function, so other than a UDF, the only other answer I know is to hijack the PARSENAME function: SELECT …

if the values in column 1 are always one character long, and the values in column 2 are always 2, you can use the SQL Left and SQL Right functions: SELECT LEFT(data, 1) col1, RIGHT(data, …

This is most like .NET, for those of you who are familiar with that function: CREATE FUNCTION dbo.[String.Split] ( @Text VARCHAR(MAX), @Delimiter VARCHAR(100), @Index INT ) …

May 14, 2012 · You can use a table-valued function STRING_SPLIT, which is available only under compatibility level 130. If your database compatibility level is lower than 130, SQL …

Feb 23, 2015 · There are multiple options. See Split single comma delimited string into rows in Oracle. You just need to add LEVEL in the select list as a column, to get the sequence number …

Jun 6, 2012 · Finally the wait is over in SQL Server 2016 they have introduced Split string function : STRING_SPLIT. select * From STRING_SPLIT ('a,b', ',') cs All the other methods to split …

Here is a simple function that could be used to split string in DB: SELECT value FROM STRING_SPLIT('Lorem ipsum dolor sit amet.', ' '); it will return all the values by splitting with …

Oct 9, 2015 · From SQL SERVER 2016 we can use sql inbuilt function STRING_SPLIT as below : SELECT * FROM JobOffers as j outer apply STRING_SPLIT(j.[Categories], ',') s left join …

The STRING_SPLIT function is available at compatibility level 130 or higher. If your database compatibility level is lower than 130, SQL Server will not be able to find and execute …

Alternate function to String_Split for older versions of SQL Server. Create this Function in your Database. Create Function dbo.Test_Split( @string varchar(4000)) Returns @Result Table …