Help please:
...

<table border>
<!-- Header -->
<tr bgcolor=#CCCCCC>
<td>
<b>AR_Number</b>
</td>
<td>
<b>State</b>
</td>
</tr>
<%
set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "select AR_Numb, State FROM TTT "
rs.Open strSQL, "DSN=Advanced;"
Do Until rs.EOF
Response.Write("<tr>")
Response.Write("<td>")
' Begin hyperlink
Response.Write("<a href='detail_tick.asp?CID=")
Response.Write(rs.Fields("AR_Numb")) & "'>"
Response.Write(rs.Fields("State") & " " & _
rs.Fields("State_Reason"))
....

Another asp: <a href: Detail_tick.asp:
...
<%
set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "select * " & _
"from TTT " & _
"where AR_Numb = " &Request.QueryString("CID")
rs.Open strSQL, "DSN=Advanced;"
Response.Write "AR_Numb: " & (rs.Fields("AR_Numb")) & "<br>"
Response.Write "Short_Description: " & (rs.Fields("State")) & "<br>"

...
When field AR_Number –number, all is OK, but field AR_Number must be in text for example:
-( 1-abcd,2-cdef and other).What I must do,that <a href work with text field AR_Numb ?

Thank you.