How to write if statement with not NULL ?

[#1]

Hello,

I have a field , from a SQL database that I would like to IF against :

If (fieldname NOT NULL, do this )

How would  I write this like above, but correctly ?

[ychaitanya · Accepted solution]

if( isNull('Fieldname'),'null conditon','not null conditon');

This will work..

Thanks

Chaitanya

[sushil353]

Hi,

try below code:

If(not isnull(filedname) ,1,0)

HTH
Sushil

[its_anandrjs]

Try with

If( IsNull(fieldname) = 0, do this )

Or

If( Not IsNull(fieldname), do this )

Regards

Anand

[amit_saini]

Try this:

=if (not isnull(Plant_ShortName),Plant_ShortName & ' - ' & Plant_FullName)

Thanks,

AS

[anbu1984]

If (IsNull(fieldname> <> -1, 'do this' )

[#7]

Thanks , that worked perfectly !