-1

i got a column with a value something like this.

digits
1,2,3
12,4,5
3,45,56

and i want to split the value in the row into individual, is there any simple way to do this in SQL ? im using vb.net. thanks in advance

Andrey Korneyev
  • 26,353
  • 15
  • 70
  • 71
yoyie yoyie
  • 415
  • 1
  • 8
  • 20
  • which DBMS ???. > _is there any simple way to do this in SQL ?_ < **Yes** but you need to specify in which Database that you want perform this task – Vivek S. Nov 26 '14 at 08:15
  • possible duplicate of [Tsql split string](http://stackoverflow.com/questions/10914576/tsql-split-string) – AHiggins Nov 26 '14 at 16:29

1 Answers1

0

TRY THIS:

 SELECT GROUP_CONCAT((digits) SEPARATOR ', ') as digits FROM table                                         
PACMAN
  • 41
  • 13
  • I am confused to your question and im trying to understand, but try my updated query if my sample query may help. – PACMAN Nov 26 '14 at 23:45