Data Convert Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Data Convert Functions
  4. Returning the First Non NULL Value in a List of Expressions
5> DECLARE @Value1  int
6> DECLARE @Value2 int
7> DECLARE @Value3 int
8> SET @Value2 = 22
9> SET @Value3 = 955
10> SELECT COALESCE(@Value1, @Value2, @Value3)
11> GO
-----------
         22
(1 rows affected)
1>