Mega Code Archive

 

Categories / MSSQL Tutorial / Data Convert Functions

 

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>