Home > IT Answers > AS/400 > iSeries SQL ISNULL Equivalent
Jaggerdude
60 pts.
 iSeries SQL ISNULL Equivalent
iSeries SQL, iSeries Access, AS/400, iSeries Navigator, T-SQL
What is the equivalent of the function ISNULL in t-sql in AS/400 iSeries Navigator SQL? or the equivalent of the NZ function in Access?
ASKED: Jan 26, 2011  10:28 PM GMT
UPDATED: January 27, 2011  2:12:39 PM GMT
RELATED QUESTIONS
Jaggerdude
60 pts.
Answer Wiki:
Found the answer: IFNULL or COALESCE function....
Last Wiki Answer Submitted:  Jan 26, 2011  10:45 PM (GMT)  by  Jaggerdude   60 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

Hi,

I used IS NULL in STRSQL command, by example :

SELECT * FROM FMFIRMA WHERE FIRNUM is null

Try it, maybe this if what you need.

Mariodlg
 2,790 pts.