A person was doing a web project using Visual Studio ASP and the database using Microsoft SQL.
Problem is that this person decided to stop at the last minute and I'm now continuing what he was doing. I fixed most of the problems but I still have this problem.
I'm trying to get a number from the database and save it in a variable in VBScript and use it to compare with a number entered by the user.
I tried to use this:

dim sql : sql = "select id from name"
dim rs : set rs = createobject("adodb.recordset")
rs.cursorlocation = 3 'Use a client-side cursor
rs.open sql, conn, 3, 3

Or similar to that, but it didn't work.
The error that I have is that sql used in this example is a string and cannot compare with a number.
BTW, I'm new to VBScript so providing examples or web pages will be appreciated.