Read extremely carefully SA's comment! It explain to you why in password you need not care for case-sensitive or insensitive! A hash of HelloWorld is not the same as of helloworld!
For other data (like names in your case) if you want case-sensitive data, you have to choose the right
COLLATION[
^] for your database or use
COLLATE[
^] on a single data column/variable to make it case-sensitive or insensitive according your need!!!
Let see some sample...
Imagine we have a database with collation of Latin1_General_CI_AS, which means the Latin1 portion of unicode with case insensitive and accent sensitive comparison...
Now we have a table (Usr) with two columns - PswHash, UserName.
If we want to compare UserName case sensitive (remember the DB is case INsensitive!) we can do it like this...
SELECT *
FROM Usr
WHERE UserName = @UserName COLLATE Latin1_General_CS_AS;
Where @UserName is the variable holding the user name as written by the user on the login form...