Jeff Moden (10/18/2013)

---

jonysuise (10/18/2013)

---

Hi asranantha, 😀

I would use COALESCE AND CASE, because it's SQL standard.

I would use just ISNULL AND NULLIF (like Sean did) because you don't have unexpected datatype precedence problems with ISNULL like you can with COALESCE, is a tiny bit faster than COALESCE, takes fewer characters to type, and it ticks all sorts of people off that still think SQL is portable across engines. 😀