Skip to content

Data Empower – The Data Matrix

Search for:
Log in

Menu

Close
  • Home
  • Shop
  • Excel
    • All Excel Functions List
  • PowerBI
  • SQL
  • Fabric
  • Google sheets
    • Google Sheets All functions alphabetical
  • About
  • Home
  • Shop
  • Excel
    • All Excel Functions List
  • PowerBI
  • SQL
  • Fabric
  • Google sheets
    • Google Sheets All functions alphabetical
  • About
Search for:
Log in

Tag: isnull

  • Home
  • isnull
SQL

SQL handling NULL, Zero and Blanks when dividing by Zero and adding NULL

Written by ilyar126 February 26, 2025February 26, 2025

If you are used to working with Excel, you know that all you need is IFERROR() function to avoid any issues with dividing by 0. Also adding a blank to a number is not creating any issues in Excel. In SQL, however, its not that straight forward, you need to remember to differentiate between ISNULL() […]

Follow me on Ganjing World!

Get the SQLBits T-Shirt now!

Copyright © 2025 Data Empower - The Data Matrix | Powered by BuddyX WordPress Theme