formatting a field with SQL data.

[d.m.holdawayGA2553]

hello,

at the moment my my code pulls in some data from a SQL database, it works a treat but i am having trouble formatting it

at the moment it pulls in names from a address book for example and displays them

darren,dave,ian,simon

what i would like it to do is list them

darren
dave
ian
simon

any ideas?

[bn]

How about:

Code: Select all

replace comma with return in myNames
put myNames into field "theNames"

where myNames is the variable with the names.
Kind regards
Bernd

[d.m.holdawayGA2553]

is that it?

gosh i feel like such a idiot.... haha