<%
set rs = server.CreateObject (“ADODB.Recordset”)

SQL =”SELECT * FROM atable”

rs.open SQL, conn

response.write rs(“afield”)

rs.close

%>