Excellent post! I always follow your articles. I believe that it's possible to use CASE expressions to check for NULL. The following statement should execute properly.
SELECT game, CASE WHEN year IS NULL THEN '2020' ELSE year END AS year FROM sega_sales
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Excellent post! I always follow your articles.
I believe that it's possible to use CASE expressions to check for NULL. The following statement should execute properly.