Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
if( isNull('Fieldname'),'null conditon','not null conditon');
This will work..
Thanks
Chaitanya
if( isNull('Fieldname'),'null conditon','not null conditon');
This will work..
Thanks
Chaitanya
Hi,
try below code:
If(not isnull(filedname) ,1,0)
HTH
Sushil
Try with
If( IsNull(fieldname) = 0, do this )
Or
If( Not IsNull(fieldname), do this )
Regards
Anand
Try this:
=if (not isnull(Plant_ShortName),Plant_ShortName & ' - ' & Plant_FullName)
Thanks,
AS
If (IsNull(fieldname> <> -1, 'do this' )
Thanks , that worked perfectly !