> Depending on what you want, you might be able to just get away with
> using coalesce on each of them...
>
> select count (distinct ( coalesce(text(advert_no), 'NULL') ||
> coalesce(text(pool_id), 'NULL' ) ) ) from redirect;
Great... This works perfectly. A bit of a monster though :-)
--
Eric Jain