[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 456
  • Last Modified:

SELECT DISTINCT

Is SELECT DISTINCT case-sensitive?  In other words, would it count "FIRSTNAME" as distinct from "Firstname"?
0
z018196
Asked:
z018196
1 Solution
 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now