TIBCO Data Virtualization® Adapter Online Help > TDV SQL Server Adapter > Microsoft SQL Server Function Support > Microsoft SQL Server Conditional Function Support
 
Microsoft SQL Server Conditional Function Support
TDV supports the conditional functions listed in the table below for Microsoft SQL Server.
Microsoft SQL Server Conditional Function
Notes
COALESCE
 
DECODE
Mapped to CASE.
ISNULL
 
ISNUMERIC
 
NULLIF
NULL literal cannot be the first argument to NULLIF function. NULLIF does not support IMAGE, NTEXT, or TEXT.
NVL