Syntax Error

Code samples and hints

Case sensitive DISTINCT

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
Kommentare sind geschlossen