I'm running a SQL statement to get a value from a table (a number).
Is there any way that I can assign the return of the sql statement to a variable?

ie: nThis = SELECT * FROM tblKeyCounter

There's only ever one record in that table... so it can only ever return one value.... but how do I assign that return to a variable?

Thanks!!