Reference Guide > TDV Support for SQL Functions > Conditional Functions
 
Conditional Functions
TDV supports the conditional functions listed in the table.
TDV-Supported Conditional Function
Comments
COALESCE
COMMON
DECODE
ES_MATCH
FILTER
IFINF
IFMISSING
IFMISSINGORNULL
IFNAN
IFNANORINF
IFNULL
IFNULLCB
ISARRAY
ISATOM
ISBOOLEAN
ISNULL
ISNUMBER
ISNUMERIC
ISOBJECT
ISSTRING
MATCH_PHRASE
MATCH_PHRASE_PREFIX
MISSINGIF
NANIF
NEGINFIF
NULLIF
NVL
NVL2
POSINFIN
TERM
TEST