Can't seem to find function like empty()

[TonyScarpelli]

In FoxPro a function called empty(fieldname) will return a boolean if the field is an empty string, all spaces, 0, etc.

Is there something in CR that is similar?

The closest I can come to is to build one like this:
Length (Trim ({pur_head.Notes})) = 0

Thanks.


Tony Scarpelli
Clinical Engineering Dept.
Maine Medical Center
Portland, Maine 04102

 

[IdoMillet]

IsNull()

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[DarkTraveller]

or...... <>""
Luck.
-D.

 

[TonyScarpelli]

But doesn't IsNull() just check for <null> and not for multiple spaces or a numeric 0?

Thanks


Tony Scarpelli
Clinical Engineering Dept.
Maine Medical Center
Portland, Maine 04102

 

[lbass]

For strings:

isnull({table.string}) or
trim({table.string}) = ""

For numbers:

isnull{table.number})

-LB