Posted on 2007-10-10
Last Modified: 2010-03-20
Is SELECT DISTINCT case-sensitive?  In other words, would it count "FIRSTNAME" as distinct from "Firstname"?
Question by:z018196
    LVL 92

    Accepted Solution

    Assuming this is SQL Server, then it depends on your collation settings.

    If this is Access, no.
    LVL 14

    Expert Comment

    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.
    LVL 16

    Expert Comment

    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...

    Featured Post

    Integrate social media with email signatures

    Is your company active on social media? Do you also use email signatures? Including social media icons in your email signature is a great way to get fans for free. Let all your email users know you’re on social media quickly and easily, in a single click.

    Join & Write a Comment

    Several part series to implement Internet Explorer 11 Enterprise Mode
    This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
    Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
    The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now