In SQL Server you can use COLLATE Latin1_General_CS_AS in your SQL to perform case sensitive queries. However, if you need to do case sensitive queries you may want to consider altering the column so that it is case sensitive. If that is not an option, here is how to use SQL.
How to select case sensitive:
where FieldName = ‘xYz‘ COLLATE Latin1_General_CS_AS
How to group by using case sensitive:
select FieldName COLLATE Latin1_General_CS_AS, count(*)
group by FieldName COLLATE Latin1_General_CS_AS