Rewriting scalar function to table function

if the select statement returns nothing from inline query, then simply return null.

In a TDF you would return nothing (= no row) instead.

---

Olaf Helper

Blog Xing