“How to use the COMPARE function?”
Comparison compares numeric substrings within the specified strings as numbers We can give any of the hardcoded or dynamic values
COMPARE(value1,value2) Example - COMPARE(‘9’,’4’) → false