Case insensitive text comparison function required on calculated fields

Currently when using calculated columns or worksheets, there is no way to do a case insensitive comparison. As a result, I need to create an if function with various permutation of cases in order to achieve my objective which is inefficient and difficult to maintain.

Use case: I am trying to check if a certain free text field contains specific text.

Request: Create a function that allows a case insensitive string comparison. i.e. stripos(field("Location"), "FOO") >=0 that would return 0 for foo or Foo or FOO as opposed to current strpos(field("Location"), "FOO") >=0 that only works for FOO.