Probably a really basic question, but in my define box if I want to say -

IF C_PHONENUMBER_LOOKUP EQ NULL
THEN 'No Phone Number Listed'
ELSE 'Primary Phone Number'

Is the proper syntax:
EQ NULL
EQ MISSING
IS MISSING
EQ BLANK
IS BLANK
something else?

Or does it only allow me to use the buttons below showing:
|
||
IF
THEN
LT
NE
NOT

etc.

Thanks

This message has been edited. Last edited by: reportmasterlvl3,

I think better way to handle the phone number is :-

 DEFINE FILE abc
NULL/A20 = IF C_PHONENUMBER_LOOKUP  LT 1 THEN 'No Phone Number Listed' ELSE C_PHONENUMBER 

It depends how C_PHONENUMBER_LOOKUP is defined. If it is defined as a relational field that is nullable, or a FOCUS field with missing on, then use:

IS MISSING

Otherwise, use:

EQ ''

quote:

LT 1

This worked, thanks!