Case insensitive string comparision in SQL server

I faced an issue where our app was not recognizing the password changes made by users. A user just changed some lower case character in his password to upper case and SQL server was not able to recognize these changes.

When I analyzed this issue I found that by default string comparisons are case insensitive in SQL server. i.e, PassWord1 = password1

I also found some ways to handle this issue, the below mentioned link provides good information on this

http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm

http://www.developmentnow.com/blog/2004/09/case-sensitive-string-comparison-in.html

Thanks