Retrieving Data Using SQL

Hi there!
I need to retrieve the return value of an SQL Statement to a variable. The SQL statement looks like this

SELECT MAX(SAL) MSAL FROM EMP

the return value should get bound into a variable in VB. Can any one help me in tracing a way out.

If you open your query using a recordset, the value will be in recordset.fields(0)

But i am Using RDO for accessing database. therefore in case of resultset would it work? i.e., something like

resultset.rdocolumns(0)

to retrieve the value.

Not sure with RDO.. I would assume so..