Skip to main content
Question

ISNULL Function

  • April 8, 2020
  • 1 reply
  • 3 views
A
Level 2
HI, I found out there is a huge difference between using ISNULL(table.column) = 1 and different type of writing this formula (table.column) IS NULL. Do you have know from where this difference comes from ? Here is example from analysis: ISNULL(BKPF.KBR_KONT_FLAG) = 1 BKPF.KBR_KONT_FLAG IS NULL

1 reply

V
Level 0
  • viana.kalve11
  • Level 0
  • 132 replies
  • May 14, 2020
Hi the only difference between the two PQL statements ISNULL() and IS NULL should be that ISNULL() returns an integer value (either 0 or 1), while IS NULL returns a boolean value (either true or false), stating if the field is empty. I tried using ISNULL() = 1 and IS NULL interchangeable and couldnt reproduce any differences of the result.


Community Code of ConductAccessibility statement