I finally finished the next SFMC #SQL guide!
This time, about nothing creating a lot of issues - a 𝐍𝐔𝐋𝐋: mateuszdabrowski.pl/docs/sql/sfmc-sql-null-functions/
Check out:
➡️ What is NULL?
➡️ Why you have to think about it when you write a query?
➡️ How to check whether you have NULLs in your data?
➡️ What you can do to solve NULL-based issues?
In other words, prepare for NULL, IS NULL vs ISNULL, COALESCE and NULLIF in @* Marketing Cloud Engagement *
More to come, so keep on querying!
2 commenti
Mateusz Dąbrowski (mateuszdabrowski.pl) Forum Ambassador
Been there, didn't factor it either in the past, @Tim Ziter - that's a massive trap for people coming from non-SQL environments and more accustomed to different languages that don't have this issue.