Not null

[#1]

what is the syntax for checking not null condition

thanks in advance

[tresesco]

If( Not IsNull(YourField/Expression), 'Not Null', 'Null')

[Anonymous]

Hi,

and sometimes (especially with flat files), it might be required to add ... and trim(Field)<>''

Regards

[maxgro]

not isnull(field)

or

len(trim(field)) > 0

[walterlh]

No IsNull(Campo)

[mohamed_ahid]

hi

isnull(field)=0