asp操作sql求和语句

select sum(aa) from bb

这个求和语句放在asp中应该怎么用  用sqlserver  可以直接打印出结果 但在asp程序中  应该怎么样把这个结果拿出来

---

sql = "select sum(aa) from bb"
rs.open sql,conn,1,1
response.write rs(0)

---

VBScript code:
sql = "select sum(aa) as cc from bb"
set rs = createobject("adodb.recordset")
rs.open sql, conn,3,3,1 'conn是你的链接资源
response.write rs("cc")
rs.close
set rs = nothing

---

select sum(aa) from bb

如果这个aa  是字符类型的  如何把它转换成 int型再求和?

---

select sum(cast(aa as int)) from bb