Case-sensitive Comparisons in SQL Server

Interesting article illustrating various ways to perform case-sensitive searches in SQL Server

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