Easy IF

When you have a multiple @If to eliminate NULLS there may be a better way:

When you have a multiple @If to eliminate NULLS there may be a better way:

 @If( LotusNotesName != "" ; LotusNotesName ;                               
             @If( LegalName != ""; LegalName :                              
                      @( NickName != ""; NickName; "Old what's his name"))) 
                                                                            
                                                                            
 @Subset(@Trim( LotusNotesName:LegalName :NickName);1)   

This will return the first non null from you list.

This was first published in March 2002
This Content Component encountered an error

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchWinIT

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchVirtualDataCentre.co.UK

Close