Export (0) Print
Expand All

ISLOGICAL Function

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Checks whether a value is a logical value, (TRUE or FALSE), and returns TRUE or FALSE.

ISLOGICAL(<value>)

Term

Definition

value

The value that you want to test.

TRUE if the value is a logical value; FALSE if any value other than TRUE OR FALSE.

The following three samples show the behavior of ISLOGICAL.

//RETURNS: Is Boolean type or Logical
=IF(ISLOGICAL(true), "Is Boolean type or Logical", "Is different type")

//RETURNS: Is Boolean type or Logical
=IF(ISLOGICAL(false), "Is Boolean type or Logical", "Is different type")

//RETURNS: Is different type
=IF(ISLOGICAL(25), "Is Boolean type or Logical", "Is different type")
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft