i have table name loan with 2 columns
while i retrieved and using recordset i got the result like the below list
<%
While not rs.eof
response.write rs(0) & "- " rs(1)
rs.movenext
wend
%>
Result is
Personal Loan – PLType1
Personal Loan – PLType 2
Personal Loan – PLType 3
Personal Loan – PLType 4
Home Loan - HLType1
Home Loan - HLType2

now i need to display the result as

Personal Loan(PLType1/PLType2/PLType3/PLType4)
Home Loan(HLType1/HLType2)

Could any one help to make the result

Do you need the new result to appear exclusively or have that result be the only one to appear

MikeDeepak,

Do not repost the queries in more than one section just for the sake of seeking quick reply. If you are not sure of to which section your query belongs, post that on one section which closely suits your query, thus saving the time of both the viewer's and yours.

FYI, This has been answered on the other thread.

Cheers

_________________________
- Vijay G
Strive for Perfection

happygv,
OK,thanks for your Information..