Power Query
Search…
Comparer.OrdinalIgnoreCase

Comparer.OrdinalIgnoreCase

Returns a case-insensitive comparer function which uses Ordinal rules to compare values.
function (optional x as nullable any, optional y as nullable any) as number

Description

Returns a case-insensitive comparer function which uses Ordinal rules to compare the provided values x and y.

Category

Comparer

Examples

Using case-insensitive Ordinal rules, compare "Abc" with "abc". Note "Abc" is less than "abc" using Comparer.Ordinal.
1
Comparer.OrdinalIgnoreCase("Abc", "abc")
Copied!
0