Bradley Deem (8/4/2010)[hrActually, with Coalesce it comes down to the expression with the highest data type precedence being returned, thus exactly 1 predictable type will be returned. Consider the following which results in an error.
Argh... Thanks for the correction, I knew that but for whatever reason wasn't thinking straight...