• An interesting question, but am I missing something here? When would you use coalesce entirely with untyped values?

    If I were using coalesce it would be to test column values or variables/parameters and in both these cases typing is specified. Can anyone think of a situation where you would be sending only untyped values?