NVL Function |  |
Returns a non-null value from two expressions.
Namespace: XSharp.VFP
Assembly: XSharp.VFP (in XSharp.VFP.dll) Version: 2.19
SyntaxFUNCTION NVL( eExpression1, eExpression2 ) AS USUAL CLIPPER
[ClipperCallingConventionAttribute(new string[] { ... })] public static Usual NVL( Usual eExpression1 = default, Usual eExpression2 = default )
Parameters
Return Value
Type: UsualCharacter, 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.
ExamplesX#
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