Robert,

To understand the difference between EMPTY(), ISBLANK(), and ISNULL() please run the following little program and look at the results.

*!* "Is there any function that can distinguish between 
*!* the zero and the apparently blank entry?"

*!* Only ISBLANK() can distinguish between 
*!* zero and "never entered" in a numeric field.

CREATE CURSOR Dummy ;
    (nDummy N NULL, nValOfDummy N NULL, lISBlank l, lISNull l, lEmpty l)
APPEND BLANK
REPLACE nValOfDummy WITH nDummy, ;
    lIsBlank WITH IsBlank(nDummy), ;
    lIsNull WITH ISNULL(nDummy), ;
    lEmpty WITH EMPTY(nDummy)
APPEND BLANK
REPLACE nDummy WITH 0
REPLACE nValOfDummy WITH nDummy, ;
    lIsBlank WITH IsBlank(nDummy), ;
    lIsNull WITH ISNULL(nDummy), ;
    lEmpty WITH EMPTY(nDummy) 
APPEND BLANK
REPLACE nDummy WITH .NULL.
REPLACE nValOfDummy WITH nDummy, ;
    lIsBlank WITH IsBlank(nDummy), ;
    lIsNull WITH ISNULL(nDummy), ;
    lEmpty WITH EMPTY(nDummy) 

BROWSE

>In vfp60, in my table… I want to check a field that has a data type of CURRENCY. I want to see if this field is empty or not. I have tried…
>?empty(myfld)….this returns a F…but the field seems to be empty....
>?myfld...returns nothing...
>Any ideas?