Splitting SQL columns by delimiter in SQL Server 12

Asked Aug 17 '22 at 12:21

Active Aug 17 '22 at 12:45

Viewed 33 times

I have a table called my_table in myDB SQL Server database.

my_table contains:

foo	bar
baz-12:1234:bom	bim
baz-34:5678:bom	bim

What select statement would return a column containing the third set of values '1234' in row 1 and '5678' in row 2?

I am using SQL Server 12.

This doesn't work:

SELECT STRING_SPLIT(foo) 
FROM my_table

edited Aug 17 '22 at 12:45

marc_s

asked Aug 17 '22 at 12:21

cristiandatum

1

Do you mean SQL Server 2012? – Dan Guzman Aug 17 '22 at 12:25
1

Or perhaps SQL Server 2014, which is version 12? – Thom A Aug 17 '22 at 12:30
2012 or 2014 is irrilevant, String_split will need SQL Server 2016 – user_0 Aug 17 '22 at 12:33
1

At least, I suppose, 2014 is still in (extended) support, @user_0 . 2012's support has completely expired now – Thom A Aug 17 '22 at 12:35

0 Answers0