case sensitive

[Mark_Meng]

Select * from psUser where Password = 'Password' and userid = 'userid'

if recordcount > 0 then -------

Can I ask you how to make this case sensitive. Because I want to check password and userid by case sensitive

[monte96]

SELECT 
     *
FROM 
     psUser
WHERE 
     StrComp(Password, "Password", 0) = 0 AND
     StrComp(userid , "userid", 0) = 0

You can check this out from MSDN. Now, the article is about joins, but the theory is the same.