[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
+---------------------------------+
| EMPTY |
+---------------------------------+
EMPTY(<expr>)
-----------------------------------
Determines if <expr> is blank.
Return value - Logical
-----------------------------------
This function returns the logical value true (.T.) if the expression
<expr> is "blank". EMPTY() will return .T. when the following data type
expressions evaluate to:
Character White space
Numeric 0
Date Null (i.e. CTOD(''))
Logical False (.F.)
Memo Empty (no memo contents)
White space in a character expression includes nulls, spaces, tabs,
carriage returns or line feeds or any combination of these.
If the <expr> is not blank, EMPTY() returns false (.F.).
+---------------------------------+
| Program Example |
+---------------------------------+
In this example, CUSTOMER database has filter set which recognizes only
those records that do not have empty memo field (COMMENTS).
CLOSE ALL
USE customer
SET FILTER TO NOT EMPTY(comments) && Non-empty memos
BROWSE LAST
SET FILTER TO
-----------------------------------
See Also: LEN()
-----------------------------------
See Also:
LEN()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson