JCurve Solutions Support Hub

SQL Function: Decode

The following table outlines the SQL Decode function that can be used in NetSuite search formulas and custom formula fields:

Function

Syntax

Short Descriptions

Example

DECODE

DECODE(expr, search, result

[, search, result ]...

[, default ]

)

Compares expr to each search value one by one. If expr is equal to a search, the corresponding result is returned. If no match is found, default is returned.

DECODE({‌systemnotes.name}, {assigned},'T','F')

Looking for something else? Search here...