Logically checks to see if a list of boolean conditions are true or false. Returns
true if the list of conditions are true, and
false if one or more is false. Any null value is considered false.
bool? AND(params bool? conditions)
false as the COMPARE returns
AND(COMPARE("Apples", "apples", true))
true as the COMPARE returns
true as "Apples" is the same as "apples" when the case is ignored.