Type Functions

In This Topic

Syntax	Description	Example
EMPTY()	Returns the empty variant value.	EMPTY() Returns: the empty variant
ISARRAY(var)	Returns true if the variant is array. Otherwise returns false.	ISARRAY(ARRAY(10,20)) Returns: true ISARRAY(10) Returns: false
ISBOOL(var)	Returns true if the variant is a boolean. Otherwise returns false.	ISBOOL(true) Returns: true ISBOOL(false) Returns: true ISBOOL("true") Returns: false
ISDATETIME(var)	Returns true if the variant is a date time. Otherwise returns false.	ISDATETIME(10) Returns: false ISDATETIME(DATETIME("2008-09-15T09:30:41.770")) Returns: true
ISEMPTY(var)	Returns true if the variant is empty. Otherwise returns false.	ISEMPTY(EMPTY()) Returns: true ISEMPTY(true) Returns: false
ISNUM(var)	Returns true if the variant is a number. Otherwise returns false.	ISNUM(10) Returns: true ISNUM(true) Returns: false
ISSTR(var)	Returns true if the variant is a string. Otherwise returns false.	ISSTR(true) Returns: false ISSTR("hello world") Returns: true
ISTIMESPAN(var)	Returns true if the variant is a time span. Otherwise returns false.	ISTIMESPAN(true) Returns: false ISTIMESPAN(TIMESPAN("10.20:30:40.50")) Returns: true
TOBOOL(var)	Safely casts a variant to a boolean variant. Returns EMPTY, if the cast cannot be performed.	TOBOOL("false") Returns: false TOBOOL("true") Returns: true TOBOOL("hello") Returns: the empty variant
TODATETIME(var)	Safely casts a variant to a data time variant. Returns EMPTY, if the cast cannot be performed.	TODATETIME("2008-09-15 09:30:41.770") Returns: the date and time TODATETIME("hello") Returns: the empty variant
TONUM(var)	Safely casts a variant to a number variant. Returns EMPTY, if the cast cannot be performed.	TONUM(true) Returns: 1 TONUM("10") Returns: 10 TONUM("hello") Returns: the empty variant