Hello, I have the problem, that MSSQL Server 2000 should select some distinct values from a table (the specific column is of the nvarchar type). There are the sometimes the same values, but with different cases, for example (pseudocode):

SELECT DISTINCT * FROM ("A", "a", "b", "B")

would return

A,b

But I do want (and do expect)

A,a,b,B

because they actually are different values.

Any idea how to solve this problem?

Thanks a lot in advance!