[<<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