SELECT DISTINCT

Is SELECT DISTINCT case-sensitive?  In other words, would it count "FIRSTNAME" as distinct from "Firstname"?
z018196Asked:
Who is Participating?
 
Patrick MatthewsCommented:
Assuming this is SQL Server, then it depends on your collation settings.

If this is Access, no.
0
 
cuziyqCommented:
By default, SQL is not case sensitive in any way.  However, if you desire case-sensitivity, you can change the coallation mode of the server.  Here's a link on how to do it in SQL Server 2000.  You can Google it pretty easy if you're trying to do it in something else.

http://sqlserver2000.databases.aspfaq.com/how-can-i-make-my-sql-queries-case-sensitive.html
0
 
SQL_SERVER_DBACommented:
Is SELECT DISTINCT case-sensitive? No, I wouldn't mess with the collation settings unless you know what your doing. But just like cuziyg says, you can make sql queries case sensitive...

good luck...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.