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
Printable View
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
You can check this out from MSDN. Now, the article is about joins, but the theory is the same.Code:SELECT
*
FROM
psUser
WHERE
StrComp(Password, "Password", 0) = 0 AND
StrComp(userid , "userid", 0) = 0