>>What is wrong with CAST(null as int)? Why the Coalesce is necessary?
>
>Because he wanted to get 0 as the field's value, I assume.
Ah, I misunderstood when you said "the trick is to use coalesce", now I get what you meant.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges