Using SQL Server 7 db. How do I deal with multivalued fields, as far as displaying them on a web page using ASP. Need to be pointed in the right direction.

Mike

__________________
Mike

Hi Mike,

Can you post the query you want to display & how you'd like to see it?

Cheers,

Chris

using this to display first record of multivalued field
Dim strIchar, strItext, intIcount, strIname

strIchar = chr(178)
strItext = RS("i_name")
intIcount = Instr(strItext, strIchar)

If intIcount = "0" Then
    Response.Write strItext
Else
    strIlname = mid(strItext, 1, intIcount-1)
Response.Write strIname
End If

I need to display rest of data and would like to maybe insert a carriage return at every point where a special character lies that serparates each record.

Mike

Hi Mike,

Hope this is what you are after...
Cheers,

Chris

it worked.

Thanks Chris

Mike