Login with a case sensitive password with a Stored Procedure

I have a stored procedure that validates a user login against a username and password field.
How can I ensure case sensitivity in the stored procedure for the password field?Hi

If you cast both the inputted password and the stored password as varbinary, if they are not the same case they will not match.|||OK i tried it but how do I change the the user input from a string a varbinary for the
Stored procedure input parameter ?|||I figured it out.
Thank you, merkin|||If you use MD5 to encrypt the password then it will be case sensitive and won't be crackable if the table becomes visible to a hacker.