Case insensitive search

[blackrose00961]

Hello!
I’ve got in my DB objects with names. The names can consist of uppercase and lowercase letters
The questions is how can I find names not depeding on the case?
For example, If there’s a name iPhone, how can I find that object typing iphone

[mikeloc]

Hi there, @blackrose00961… if you haven’t come across this thread yet, check it out… it might be helpful.

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 (“…

Best…
Mike