Skip to main content

Boolean

Function NameDescription
IS [NOT] DISTINCT FROMCompares two expressions to determine whether they have the same or different values. NULLs are considered as comparable values.
ISDATEReturns true if the input expression can be cast to a date.
IS [NOT] FALSETests whether the input expression is either false or not false. If true in either case, returns a value of true. Alias for the function ISFALSE/ISNOTFALSE.
IS [NOT] NULLDetermines if an expression is NULL or not NULL. Alias for the function ISNULL/ISNOTNULL.
ISNUMERICDetermines whether an expression is a valid numeric type (DECIMAL, DOUBLE, INT, BIGINT, VARBINARY).
IS [NOT] TRUETests whether the input expression is either true or not true. If true in either case, returns a value of true. Alias for the function ISTRUE/ISNOTTRUE.
IS_MEMBERReturns whether the current user is a member of the specified role. This function cannot be used in a reflection.
IS_SUBSTRReturns true if a string is contained within another string. The comparison is case-sensitive.