I have the following code which displays data from a mdb. There is a reference to a web address in the code and I would like to display this as a hyperlink on my asp page but don't know how too. Can any one help?
<%
dim RSc
set RSc=server.CreateObject("adodb.recordset")
RSc.open "Comp", "DSN=comp1"
RSc.MoveFirst
Response.Write "<TABLE ALIGN='CENTER' BORDER='0' cellspacing='2' width='700'>"
Do while NOT RSc.EOF
Response.Write "<TR><TD align='center' width='20%'><font face='verdana' size='1'>" & RSc("Product Name") & "</TD></font>"

Response.Write "<TD align='center' width='20%'><font face='verdana' size='1'><a href='" & RSc("Web Site") & "'></a></TD></font>"

Response.Write "<TD align='center' width='20%'><font face='verdana' size='1'>" & RSc("Type") & "</TD></font><TR>"
RSc.MoveNext
Loop
Response.Write "</TABLE>"
%>