Is it possible to perform a case insensitive search?

[mikeloc]

This thread comes to mind when this topic comes up.

Why oh why am I unable to search the DB case insensitive?

@Bubble, I want to search for a value using “Do a search for” case insensitive. Since “Do a search for” requires a value, and it seems it’s case sensitive, it’s unable to find all potential values with the same characters. Let’s say I have a Data type with a Company Name field and Microsoft already exists. When someone else tries to add a new record with the same Company Name I want to disallow submission. So I want to ensure that all variations of case that a user types into an input field (“…

Spoiler alert: you won’t find a silver bullet in that thread, but it’s probably still worth a read.