| Syntax | Description | Example |
|---|---|---|
| EMPTY() | Returns the empty variant value. |
EMPTY() |
| ISARRAY(var) | Returns true if the variant is array. Otherwise returns false. |
ISARRAY(ARRAY(10,20)) |
| ISBOOL(var) | Returns true if the variant is a boolean. Otherwise returns false. |
ISBOOL(true) |
| ISDATETIME(var) | Returns true if the variant is a date time. Otherwise returns false. |
ISDATETIME(10) |
| ISEMPTY(var) | Returns true if the variant is empty. Otherwise returns false. |
ISEMPTY(EMPTY()) |
| ISLENGTH(var) | Returns true if the variant is a measure with unit from the length dimension. |
ISLENGTH(10) |
| ISMASS(var) | Returns true if the variant is a measure with unit from the mass dimension. |
ISMASS(10) |
| ISMEASURE(var) | Returns true if the variant is a measure of some kind. |
ISMEASURE(10) |
| ISNUM(var) | Returns true if the variant is a number. Otherwise returns false. |
ISNUM(10) |
| ISSTR(var) | Returns true if the variant is a string. Otherwise returns false. |
ISSTR(true) |
| ISTIME(var) | Returns true if the variant is a measure with unit from the time dimension. |
ISTIME(10) |
| TOBOOL(var) | Safely converts a variant to a boolean variant. Returns EMPTY, if the conversion cannot be performed. |
TOBOOL("false") |
| TODATETIME(var[,sCulture]) | Safely converts a variant to a data time variant. Returns EMPTY, if the conversion cannot be performed. When strings a provided as argument they are by default parsed according to the current thread culture. If culture is provided the string is parsed according to that culture. |
DAY(TODATETIME("1/2/2008", "en-US")) |
| TONUM(var[,sCulture]) | Safely converts a variant to a number variant. Returns EMPTY, if the conversion cannot be performed. When strings a provided as argument they are by default parsed according to the current thread culture. If culture is provided the string is parsed according to that culture. |
TONUM(true) TONUM("hello") |
| TOSTR(var[,sCulture]) | Safely converts a variant to a string variant. The to-string conversion is by default performed according to the current thread culture. If culture is provided the conversion is performed according to that culture. |
TOSTR(10.01, "en-US") TOSTR(10.01, "de-DE") |