SQL server coalesce function
SQL Server COALESCE In this post I will explain about sql server coalesce function with example. The SQL Server COALESCE expression accepts a two or more arguments, evaluates them in order from left to right, and returns the first non-null argument or value. The following line illustrates the syntax for COALESCE expression: COALESCE(val1,[val2,…,valn])