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,094 reads
Coalesce()
2025-04-02
1,955 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,329 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,716 reads
2013-06-03
2,611 reads
2012-11-09
2,217 reads
2012-10-17
2,549 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers