Click or drag to resize

NVL Function

X#
Returns a non-null value from two expressions.

Namespace:  XSharp.VFP
Assembly:  XSharp.VFP (in XSharp.VFP.dll) Version: 2.19
Syntax
 FUNCTION NVL(
	eExpression1,
	eExpression2
) AS USUAL CLIPPER
Request Example View Source

Parameters

eExpression1 (Optional)
Type: Usual
eExpression2 (Optional)
Type: Usual

Return Value

Type: Usual
Character, Date, DateTime, Numeric, Currency, Logical, or the null value
Remarks
Use NVL( ) to remove null values from calculations or operations where null values are not supported or are not relevant.
Examples
X#
1STORE .NULL. TO glMyNull  // A memory variable containing the null value
2Clear
3? NVL(.T., glMyNull)  // Displays .T.
4? NVL(glMyNull, glMyNull)  // Displays .NULL.
See Also