Add a case insensitive comparison operator to Service Studio
850
Views
3
Comments
New
Builtin & User functions

Sometimes you want to compare text outside of an aggregate in a case insensitive manner.  To do this you need to enclose both sides of the = in ToUpper or ToLower functions.  It would be nice to have an operator to shortcut this.  

Something like: var1 ~= var2

Instead of: ToUpper(var1) = ToUpper(var2)

Changed the category to
Builtin & User functions

Though I would find it useful, ~= is a very bad choice 😄.

Not sure about the operator, but at least the function Compare, with parameter ignoreCase (which we already have in Index) - is a must have.