Example: Mapping the not-equal-to operator
The mapping for the not-equal-to operator returns a Boolean and does not contain NOT, AND, or OR, so no parentheses are required:
<FunctionMapping FunctionName="NE">
$P0 != $P1
</FunctionMapping>
The mapping for the not-equal-to operator uses the function NEQ, which contains parentheses. No additional parentheses are required:
<FunctionMapping FunctionName="NE">
NEQ (CASE WHEN $P0 IS NULL THEN ' ' ELSE $P0 END,
CASE WHEN $P1 IS NULL THEN ' ' ELSE $P1 END)
</FunctionMapping>
The mapping for the not-equal-to operator uses the AND operator. You must enclose it in parentheses:
<FunctionMapping FunctionName="NE">
($P0 IS NOT NULL AND $P1 IS NOT NULL AND $P0 <> $P1)
</FunctionMapping>