I have an SQL question....

I am doing an SQL query against a database and am trying to retrieve a value. Well how do I set that particular value to a variable.

FYI... I am using an SQL Server 2000 accessed by an ADO connection. I am trying to get the Payrate for a particular Machine.

Can anyone help.

If so... I appreciate the help.

Thank You