Difference between revisions of "NVL()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to specify an alternative value for a null expression | Function to specify an alternative value for a null expression | ||
| Line 12: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[ETOS()]], [[ISNULL()]], [[SET NULL]] | + | [[ETOS()]], [[ISNULL()]], [[SET NULL]], [[SET NULLDISPLAY]] |
| Line 30: | Line 26: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Expressions and Type Conversion]] | ||
| + | [[Category:Expressions and Type Conversion Functions]] | ||
Latest revision as of 17:21, 3 December 2009
Purpose
Function to specify an alternative value for a null expression
Syntax
NVL(<expr1>,<expr2>)
See Also
ETOS(), ISNULL(), SET NULL, SET NULLDISPLAY
Description
The NVL() function evaluates the expression in <expr1>, and if the expression does not evaluate to NULL, the evaluated result is returned. If the expression in <expr1> does evaluate to NULL, the expression in <expr2> is evaluated. If <expr2> does not evaluate to NULL, the evaluated result is returned. If both <expr1> and <expr2> evaluate to NULL, the NVL() function returns NULL.
Example
set sql to vfp set null on CREATE TABLE nullon (firstname c(20), lastname c(20)) INSERT INTO nullon (lastname) VALUES ("Smith") SELECT lastname, nvl(firstname,"Unknown") from nullon
Products
Recital, Recital Server
