Something like this should work:

SQL_query = "SELECT * FROM tablename"
RS.Open SQL_query, conn, 3

<a target=_new HREF='<%=RS("URL")%>'><%=RS("name")%></A>