COALESCE Function

[ADB1]

All,

Can someone explain how the COALESCE function works. I think it does the following, would I be correct?

COALESCE(Col1,Col2)

If Col2 is null use Col1....or is it the other way round?!

Thanks.

A.

 

[BillDHS]

It returns the first NOT NULL value from the string of attributes. Often used in place of non-ANCII Zeroifnull.

COALESCE(Col1,0) = return col1 if not NULL, 0 if NULL. Can contain more then 2 return values COALESCE(Col1,Col2,col3, 0) Returns first of attributes that is not null.

 

[ADB1]

Thanks Bill.