tencent cloud

Feedback

Logic Functions

Last updated: 2023-11-08 14:20:13
Logical functions are used to perform logical operations, and the result is a Boolean value.
Three logical statuses are available: TRUE, FALSE, and UNKNOWN (represented by NULL). Therefore, NOT TRUE is not necessarily FALSE; it can also be UNKNOWN.
Function
Description
boolean1 OR boolean2
Returns TRUE if boolean1 or boolean2 is TRUE.
boolean1 AND boolean2
Returns TRUE if boolean1 and boolean2 are both TRUE.
NOT boolean
Returns TRUE if boolean is FALSE; returns FALSE if boolean is TRUE; returns UNKNOWN if boolean is UNKNOWN.
boolean IS FALSE
Returns TRUE if boolean is FALSE; returns FALSE if boolean is UNKNOWN.
boolean IS NOT FALSE
Returns TRUE if boolean is not FALSE; returns TRUE if boolean is UNKNOWN.
boolean IS UNKNOWN
Returns TRUE if boolean is UNKNOWN; otherwise FALSE.
boolean IS NOT UNKNOWN
Returns TRUE if boolean is not UNKNOWN; otherwise FALSE.

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

7x24 Phone Support