Question: in SQL Server, I have a column which contains values like (1,2,3,4).
I need to convert this into:
A
---
1
2
3
4
Asked
Active
Viewed 26 times
0
-
EXPECTED ANSWE A 1 2 3 4 – Ganesh Oct 30 '18 at 03:05
-
What version of SQL Server do you use? – Paul Maxwell Oct 30 '18 at 03:09
-
1see: https://stackoverflow.com/questions/10914576/t-sql-split-string/10914602#10914602 – Paul Maxwell Oct 30 '18 at 03:11
-
column having coma separated data want to get 1 2 3 4 – Ganesh Oct 30 '18 at 03:14
-
Please try a query in the duplicate link, and if you still are stuck then drop a comment, and someone can reopen this question. – Tim Biegeleisen Oct 30 '18 at 03:14
-
Just in case you are using SQL Server 2017, please refer to this: [STRING_SPLIT()](https://learn.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-2017) if on any earlier version refer to the previous URL shown above. Both will split "1,2,3,4" into 4 rows – Paul Maxwell Oct 30 '18 at 03:47