SQL Server queries case sensitivity

sql sql-server sql-server-ce case-sensitive
Gold picture Gold · Aug 2, 2010 · Viewed 46.1k times · Source

I have this database:

abcDEF

ABCdef

abcdef

if I write: select * from MyTbl where A='ABCdef'

how to get: ABCdef

and how to get:

abcDEF

    ABCdef

    abcdef

Thanks in advance

forgot to write - sqlCE

Answer

D'Arcy Rittich picture D'Arcy Rittich · Aug 2, 2010

You can make your query case sensitive by making use of the COLLATE keyword.

SELECT A 
FROM MyTbl 
WHERE A COLLATE Latin1_General_CS_AS = 'ABCdef'

Related questions

Why can't I use an alias in a DELETE statement?

In SQL Server Compact Edition in Visual Studio 2010 (maybe SQL Server and SQL in general, I don't know), this command works: DELETE FROM foods WHERE (name IN ('chickens', 'rabbits')) but this command produces an error of: Error near identifier f. …

Read More
How to identify whether the table has identity column

I want to find out whether the table has an identity column or not. Table is unknown to me. I have not done the structure of the table. Using Query? I am using Sql Server Compact Edition.

Read More
Determine if table exists in SQL Server CE?

I know this is similar to this question, but I'm using SQL Server CE 3.5 with a WinForms project in C#. How can I determine whether a table exists? I know the IF keyword is not supported, though EXISTS is. Does …

Read More