Skip to main content

Datatype

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.
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_BIGINTReturns TRUE if the input expression is an big integer value.
IS_INTReturns TRUE if the input expression is an integer value.
IS_SUBSTRReturns true if a string is contained within another string. The comparison is case-sensitive.
IS_VARCHARReturns TRUE if the input expression is a varchar value.
SIZEReturns the number of entries in a map expression.
TYPEOFReports the type (in string format) of the input expression.