The following table outlines the SQL NULL-Related function that can be used in NetSuite search formulas and custom formula fields:
|
Function |
Syntax |
Short Description |
Example |
|---|---|---|---|
|
COALESCE |
COALESCE(expr [, expr ]...) |
returns the first non-null expr in the expression list. |
COALESCE |
|
NULLIF |
NULLIF(expr1, expr2) |
compares expr1 and expr2. If they are equal, then the function returns null. If they are not equal, then the function returns expr1. |
NULLIF({price}, 0) |
|
NVL |
NVL(expr1, expr2) |
lets you replace null with the second parameter. |
NVL({quantity},'0') |
|
NVL2 |
NVL2(expr1, expr2, expr3) |
If expr1 is not null, then NVL2 returns expr2. If expr1 is null, then NVL2 returns expr3. |
NVL2({location}, 1, 2) |