Category: SQL

SQL Coalesce “Duh”

SQL Coalesce “Duh”

As some may know, the SQL COALESCE statement will replace any nulls it finds with some other value. This function is a rock and staple of coding in SQL. It is similar to the ISNULL SQL function except it returns the non-null value instead of a boolean without having to write an “if” statement, and is extremely useful in “SELECT” statements.

Read More Read More