What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 131 Stack Exchange communities.

Why is the like operator case sensitive in data explorer? Which database is being used on the backend? Sql Server's like operator was case insensitive the last time I checked.

share|improve this question

2 Answers 2

up vote 3 down vote accepted

I believe it just depends on the default collation in use. You ought to be able to change it with the COLLATE clause, but I don't have the syntax right, or know the valid collations with out looking them up.

I have now located a query to retrieve the available collations.

And I did have the syntax right, now updated to show the variation.

share|improve this answer

Its like @MarkHurd said, it depends on the collation of the database, if its case sensitive, then comparisons like = or LIKE are gonna be case sensitive. You can do a query and force a collation that is case insensitive. Something like this:

SELECT TOP 10 *
FROM Posts
WHERE Body LIKE '%something%' COLLATE Modern_Spanish_CI_AS
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .