O'Reilly logo

Mastering SQL Queries for SAP Business One by Gordon Du

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required