How to give comma seprator when RS is returned multiple results?

[prasannadr]

Friends,

I am beginner for QTP. please help me and guide me to reach my goal.

Code:

My RS - ' Test1 = Connect.Execute ("select EMPID from EMPTBL")'
datatable.value("ABC",dtlocalsheet)

Question: i am getting multiple results for the EMPID column. i want to give comma seprator for each result and write in Datatable . How can i script it?
guide me if my way of scripting is wrong to get the multiple results.

Result: i am getting the result and dttable value like 101102103104105 but i want the value like 101,102,103,104,105


Thanks in advance
Prasanna