Constantin Lungudatawise.dev·Mar 25, 2024COALESCE vs IFNULL vs NULLIF in BigQueryWhat are they and when to use them? - IFNULL tests a column for the NULL value, returning the original value if it is NOT NULL and the second value we provide otherwise. The two columns need to be coercible to the same datatype. It's works like ISNUL...75 readsPractical BigQuerySQLAdd a thoughtful commentNo comments yetBe the first to start the conversation.