Some important functions to return values
Some important functions to return values are discussed as follows:
ISNULL() predicate
An ISNULL() function is used for replacing Null with the specified replacement value.
The syntax for the function is as follows:
ISNULL (Value1,Value2)
Value1 is normally a column value or a variable to be checked. Value2 is a fixed value to be replaced to.
In the first example query you read before the discussion of statement, there is an instance of ISNULL(T0.Debit,0) or ISNULL(T0.Credit,0). Here, a column T0.Debit or T0.Credit is checked. If it is Null, then it will be replaced with 0. Otherwise, the query will not be able to return the correct results. That is because: only 0 can be added but not Null. Even if you have ...
Get Mastering SQL Queries for SAP Business One now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
