Typ, så här
sql ="SELECT Username, AnvId FROM tabell WHERE " & _
" Username = '"& trim(request.form("Username")) &"'"
set rs = conn.execute(sql)
If rs.eof then
response.write "<p>finns ingen med det namnet</p>"
else
Response.Redirect("profilen.asp?AnvId="&rs("AnvId")&"")
End If
mvh Jörgen