Case sensitive DISTINCT Michael-R-Albertin 11.09.2012 SQL case, distinct share Facebook Twitter Google + LinkedIn Pinterest Email Share... To get a case sensitive DISTINCT result, use the COLLATE keyword ... SELECT DISTINCT Column_With_Case_Values COLLATE sql_latin1_general_cp1_cs_as FROM Case_Insensitive_Table