• actually u can use isnull in all situations if u wanted to. A coalesce is a nested isnull.

    coalesce(custname, last, first) = isnull( isnull( custname, last ), first )

    Therefore a coalesce is basically a nested isnull.