EXACT

The EXACT Function

Function Group: Logical

EXACT returns true or false depending on whether the two arguments provided are identical.

Syntax

EXACT(arg1, arg2)

• arg1 is a string
• arg2 is also a string

Uses

Let's say we receive some vendor information like that shown below:

{  
   "data":{  
      "vendor":{  
         "vendor_1":{  
            "name":"Jiffylube",
            "price":2500
         },
         "vendor_2":{  
            "distributor":"Exxon",
            "price":1500
         },
         "vendor_3":{  
            "distributor":"Jiffylube",
            "price":2000
         }
      }
   }
}

If we want to determine whether two vendor distributors were the same, we could examine the distributor keys for sameness:

EXACT(data.vendor.vendor_1.distributor, data.vendor.vendor_2.distributor)

This will return true.