Hello,
I am writing an app that retrieves data from an access data base to a
dbgrid control.
the sql statement I am using - is getting multiple values in one field (from
different tables).
Since I want to transform the data in the cell from: value1,value2, value3
ect' (in a row) to:
value1
value2
value3
ect'
(in a column), not necessarily in a dbgrid - can be in a list box as well, I
need to access the values in the field of the dbgrid.
I tried all I can think of - but nothing worked.

I will appreciate any pointers, or even another way of getting the same
result I am looking for.
thanks in advance
Dani





[email protected]
http://www.path.co.il
ICQ: 13610258