Skip to main content
shwetak961
New Participant
Dec 12, 2022 8:47 AM UTC
Question

Find Case Insesitive text in our data

Hi

I want to add a uniqueness validation on a particular data

for eg. as a user, if i enter "AbCde12"

so it should check that existing data should not contain this value in case insensitive form.

How to get the list of all permutation an combination of this value "AbCde12".

Thanks & Regards

Shweta

    1 reply

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    Dec 12, 2022 9:01 AM UTC

    The equals operator "=" ignores casing. "ABC" = "abc" -> true.

    But, is this about a database query? I would just store all values in lower or upper case. Then, finding duplicates becomes simple.

    Terms & ConditionsAccessibility statement