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.
Its like @MarkHurd said, it depends on the collation of the database, if its case sensitive, then comparisons like
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