makeing compareson case sensetive

[Phip]

How would i make something like this case sensetive?

strSQL = "SELECT * FROM user_key WHERE username='" & Request.Form("username") & "' And password='" & Request.Form("password") &"';"

so if the it doesn't match case sensetive it will return EOF

[oracleguy]

Originally posted by Phip
How would i make something like this case sensetive?

strSQL = "SELECT * FROM user_key WHERE username='" & Request.Form("username") & "' And password='" & Request.Form("password") &"';"

so if the it doesn't match case sensetive it will return EOF

If you use a rs("Password")=Request.Form("Password")

then it will be case sensitive... i think. 'rs' is whatever your recordset is.

[Phip]

thanks.