<div>
One easy way.<br />
<br />
SELECT &nbsp; distinct Name COLLATE Latin1_General_CS_AS<br />
FROM &nbsp; &nbsp; &nbsp;Employees<br />

</div>


One easy way.

SELECT   distinct Name COLLATE Latin1_General_CS_AS
FROM      Employees


<div>
<div class="content wysiwyg-content">
Hi,<br />
My database is set to be case insensitive.<br />
Is there a way to case sensitive DISTINCT query?<br />
i.e.<br />
My table Employees has columns Name and Email<br />
Name &nbsp; &nbsp; &nbsp; Login<br />
George &nbsp; 10 AM<br />
Tom &nbsp; &nbsp; &nbsp; &nbsp;10 AM<br />
Tom &nbsp; &nbsp; &nbsp; &nbsp;11 AM<br />
Tom &nbsp; &nbsp; &nbsp; &nbsp;12 PM<br />
TOM &nbsp; &nbsp; &nbsp;10 AM<br />
TOM &nbsp; &nbsp; &nbsp;11 AM<br />
TOM &nbsp; &nbsp; &nbsp;1PM<br />
<br />
When i query select distinct name from Employess, the result set is<br />
George, Tom as expected.<br />
<br />
How can I query so that result set is George, Tom, TOM?<br />
<br />
Thanks<br />
Jamie<br />

</div>
</div>


Hi,
My database is set to be case insensitive.
Is there a way to case sensitive DISTINCT query?
i.e.
My table Employees has columns Name and Email
Name       Login
George   10 AM
Tom        10 AM
Tom        11 AM
Tom        12 PM
TOM      10 AM
TOM      11 AM
TOM      1PM

When i query select distinct name from Employess, the result set is
George, Tom as expected.

How can I query so that result set is George, Tom, TOM?

Thanks
Jamie


Is there a way to case sensitive DISTINCT query?

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.