The Subtle Differences Between COALESCE and ISNULL
See how ISNULL and COALESCE behave in different situations and ensure you know which one to pick when.
2025-04-18
5,050 reads
Coalesce()
2025-04-02
1,953 reads
Using Coalesce to Clean Up Reports
One of the lesser used functions is COALESCE(), used to allow you to return one value from a list of those that are potentially NULL. This short pieces gives a few examples where this is useful?
2021-08-16
4,311 reads
2018-05-18
978 reads
2016-01-29
1,685 reads
COALESCE in SQL Server
Sandeep Mittal provides an introduction to the COALESCE function and shows how to use it.
2015-11-25
4,572 reads
2013-09-20
2,715 reads
2013-06-03
2,609 reads
2012-11-09
2,216 reads
2012-10-17
2,543 reads
Blogs
Monday Monitor Tips: Native Replication Monitoring
By Steve Jones
Redgate Monitor has been able to monitor replication for a long term, but it...
Advice I Like: Art
By Steve Jones
Superheroes and saints never make art. Only imperfect beings can make art because art...
Why Optimize CPU for RDS SQL Server is a game changer
One feature that I have been waiting for years! The new announcement around optimize...
Forums
Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL
Comments posted to this topic are about the item Think LSNs Are Unique? Think...
The AI Bubble and the Weak Foundation Beam
Comments posted to this topic are about the item The AI Bubble and the...
Question of the Day
A Big PK
In SQL Server 2025, how many columns can be included in a Primary Key constraint?
See possible answers