Re: creating view - conditional testing in construct

On Sat, Oct 24, 2009 at 5:41 AM, richard terry <rterry(at)pacific(dot)net(dot)au>
wrote:

On Saturday 24 October 2009 09:28:44 richard terry wrote:
>
> I've just implemented nathanial's solution and it solves my problem -
> thanks -
> but I'd still be interested in sampel of using COALESCE.
>

select coalesce (v.title, '') || ' ' ||
coalesce (v.firstname, '') || ' ' ||
coalesce (v.surname, '') || '( ' ||
coalesce (v.occupation, '') || ') ' ||
coalesce (v.organisation, '') || ' ' ||
coalesce (v.branch, '') as summary
from vworganisationsemployees as v;

But probably you want to use case, because with this approach you will still
get an extra space padding if something is null. With case, you can handle
that more elegantly, as already described.

Cheers,
--
Casey Allen Shobe
casey(at)shobe(dot)info