← Back to Comparer functions

Comparer.OrdinalIgnoreCase

This function returns a comparer that ignores letter case and uses Ordinal rules to compare the values x and y provided.

Syntax

Comparer.OrdinalIgnoreCase(x as any, y as any) as number

About

This function returns a comparer that ignores letter case and uses Ordinal rules to compare the values x and y provided.

Explanation

When utilizing Ordinal rules, a case-insensitive comparison was conducted between "Abc" and "abc". The comparison indicated that "Abc" is considered less than "abc" when using the Comparer.OrdinalIgnoreCase function in Power Query M. The output of this comparison is 0.