Nikki

Nikki

  • NA
  • 103
  • 3.1k

fuction to split by comma from a string

Sep 5 2018 6:36 AM
Hi,
 
I have a string in sql like '200,209.4,450,680.02,3500,3400.02,3000,123,855.98'
 
I want a rsult by function like this
1     200
2    209.4
3    450
4    680.02
5    3500
6    3400.02
7    3000
8    123
9    855.98 
 
Please help me.

Answers (5)