returns the first non-null value in SqlServer

علی ذوالفقار
1402/11/14 20:57:15 (14)
The COALESCE() function returns the first non-null value in a list.        
SELECT COALESCE(NULL, 1, 2, 'test'); 
return => 1
Back