Difference between revisions of "NVL()"
From Recital Documentation Wiki
Helengeorge (Talk | contribs) (→Class) |
Helengeorge (Talk | contribs) |
||
| 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 28: | 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]] | ||
[[Category:Expressions and Type Conversion Functions]] | [[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
