Hi
I have a variable myvar char(100).
I have assign a value to it myvar='abc,bb,xft,gty'
First I want to check how many , are there in this variable.
second I want to get the value from this variable before each comma like:
abc
bb
xft
gty

I am working on db2 databse.

Regards
Anshul