SQL Server Distinct – Make it Case Sensitive


By default SQL Server DISTINCT is NOT case sensitive. This means that if you had the following data in a table: FirstNames Richard Adam James Adam Ryan RICHARD Richard and queried this table with “SELECT DISTINCT FirstNames FROM table” you would get: FirstNames Richard Adam James Ryan However, there are occasions where you want the case taken into account. Change the query to include...



Get in touch

I'm available on just about every social media platform out there as RMTWeb.