Josh,
So, you have a column with some upper case and lower case values. By default, SQL Server treats upper case and lower case the same. The case sensitivity can be set at the Server, Database, or Column level as well as on a query by query basis...
