[this page | pdf]

Function Description

Returns a value of -1, 0 or +1 depending on whether InputString1 is deemed less than, equal to or greater than InputString2.


If IsCaseSensitive is true then function uses ‘binary’ comparison so differentiates between upper and lower case letters, otherwise uses ‘text’ comparison and so does not differentiate between upper and lower case letters.


Contents | Prev | Next

Links to:

-          Interactively run function

-          Interactive instructions

-          Example calculation

-          Output type / Parameter details

-          Illustrative spreadsheet

-          Other String functions

-          Computation units used

Note: If you use any Nematrian web service either programmatically or interactively then you will be deemed to have agreed to the Nematrian website License Agreement

Desktop view | Switch to Mobile