Some important functions to return values are discussed as follows:
An ISNULL() function is used for replacing Null with the specified replacement value.
The syntax for the function is as follows:
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.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 ...