While the discussion has been about comparing this technique to words and text, it is also a way to handle leading wildcard searches on part numbers. I have done...

Eric M Russell (2/2/2012)

---

On some SQL database engines, even the behaviour of NULL doesn't conform to ANSI standards. When I first started working with Oracle, I kept tripping over the...

SQL Kiwi (2/2/2012)

---

carlos.magno (2/2/2012)

---

The "BIG" problems that this Microsoft articles describes with Coalesce are just if you are using a subquery inside the function.

But I guess that is not...

I am in the habit of using COALESCE for such things, mainly because I also use MySql, which doesn't have ISNULL. But everyone should read the link that SQL...