comparing strings

I'm trying to compare two strings.  One is an imput from a form the other comes from a record source from a SQL 2000 database.  Here is where I am stuck. 

  if request.Form("formVariable") = rs("rsvariable") then
       code code

  end if

Is it possible to do it like this.  If not what are my alternatives.  Any help would be appreciated. 

what about something like this:

Dim var1, var2

var1 = Request.Form("formVariable")
var2 = rs("rsVariable")

IF var1 = var2 THEN
...code here....
END IF

KCWebMonkey,

     what you suggested would not give me the results I wanted.  It compared the strings but paid no attention to uppercase or lowercase.  The strComp is what I was looking for.

Thanks though,

Cyber "the mad scientist"