I have this line of code and it returns a value. I would like to return a href value instead like

response.write("<table>")
do until rs.EOF
for each x in rs.Fields

response.write("<tr><td><b>" & x.name & "</b></td>")
response.write("<td>" & x.value & "</td></tr>")
next
rs.MoveNext
loop

it returns two values a link and a title from the database
I would like to display the Title of the field with a HREF to the link

Not sure if I have understood your objective properly and sorry to change you syntax style, anyhow

<table>
<%
do until rs.EOF
   for each x in rs.Fields %>
      <tr>
       <td><b><%= x.name %></b></td>
       <td><a href="<%= x.value %>" title="Click to ...">Click to....</a></td>
      </tr>
<% next
   rs.MoveNext
loop%>
</table>

Wind is your friend
Matt