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 (http://support.microsoft.com/support/kb/articles/Q244/6/93.ASP). Now, the article is about joins, but the theory is the same.