The Many Uses of Coalesce in SQL Server

https://www.mssqltips.com/sqlservertip/1521/the-many-uses-of-coalesce-in-sql-server/

Many times people come across the Coalesce function and think that it is just a more powerful form of ISNULL. In actuality, I have found it to be one of the most useful functions with the least documentation. In this tip, I will show you the basic use of Coalesce and also some features you probably never new existed.

Source: Ken Simmons, MSSQLTips.com
Viewed 8961 times