“SELECT DISTINCT” ignores different cases

by

The collation will be set to case insensitive.

You need to do something like this

Select distinct col1 COLLATE sql_latin1_general_cp1_cs_as
From dbo.myTable

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. Max sal to print base on manager_id
  3. Can I use CASE statement in a JOIN condition?
  4. sql server 2008 management studio not checking the syntax of my query
  5. Create a date from day month and year with T-SQL
  6. How to create a table from select query result in SQL Server 2008 [duplicate]
  7. Creating an index on a table variable
  8. Get the week start date and week end date from week number
  9. Parse comma-separated string to make IN List of strings in the Where clause
  10. conditional unique constraint
  11. How do I execute a stored procedure once for each row returned by query?
  12. SELECT FOR UPDATE with SQL Server
  13. How to group by month from Date field using sql
  14. Why is my t-sql left join not working?
  15. PIVOT query on Distinct records
  16. SQL Server Update Trigger, Get Only modified fields
  17. Grouped string aggregation / LISTAGG for SQL Server
  18. Curly braces in T-SQL
  19. Performance of SQL Server 2005 Query
  20. OPENXML with xmlns:dt
  21. Custom Date/Time formatting in SQL Server
  22. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  23. Find min and max for subsets of consecutive rows – gaps and islands
  24. The transaction log for the database is full
  25. When using GETDATE() in many places, is it better to use a variable?
  26. Should I use the CASCADE DELETE rule? [duplicate]
  27. Dynamic order direction
  28. Why is RAND() not producing random numbers?
  29. SQL, How to Concatenate results?
  30. Should every SQL Server foreign key have a matching index? [closed]

Leave a Comment