Google+ Like somuch.com on Facebook Share somuch.com on Facebook somuch.com on Twitter Reddit LinkedIn Pinterest Google PR6
Newest Tips & Tricks...

Home :: Tips & Tricks :: Microsoft SQL Server

The Many Uses of Coalesce in SQL Server

http://www.mssqltips.com/tip.asp?tip=1521

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

Recommended Links...