Hi Walter

>
>What is COALESCE ??
>


In Firebird, the definition is:

Allow a column value to be calculated by a number of expressions,
the first expression returning a non NULL value is returned as the
column value


I don't know if is the same in MSSQL, but I'll bet that it is.