numbers of the recordset are used as<BR>sVariable=Rs(0)<BR>where RS(0) is the first column of the recordset return.<BR>when you call the column specifically, you use<BR>sVariable=RS("Columnname")<BR>you can use either. from a debugging perspective, it is better to use RS("columnname") but may not be the best for performance.
Numbers are numbers and don't need string delimiters ('). Everthing is working because your database probablly automatically converts your string values (those values enclosed in single quotes (') ) to numeric values.
You are probably using Access, yes? It's sometimes too flexible for its own good.<BR><BR>(And you confused one poor respondent with your example..."'" & rs("field") & "'" ... you probably meant to use something like "'" & Request.Form("xyz") & "'", yes?<BR><BR>I might note that you *are* making the DB server do a *tiny* bit more work...figuring out that you are passing a string where a number is called for and then having to invoke a "cast" or "convert" operation to convert the string to a number...but it's admittedly just a tiny bit of work, as it would have to convert the SQL text from ASCII to numeric anyway.<BR><BR>Anyway, some DBs will choke on the '99' format, so it's a good idea to get in the habit of presenting number as numbers.<BR><BR>