Re: coalesce

thanks,

so I take it I am not getting those more complex examples (that are
apparently beyond my use case), I will take a look at them again.

Thank you for the feedback.

On Wed, Sep 21, 2011 at 10:33 AM, Kevin Grittner <
Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:

> Henry Drexler <alonup8tb(at)gmail(dot)com> wrote:
>
> > "If the results of the first argument are null, it will return the
> > second."
>
> Unless the second is also null, in which case it will return the
> third. Unless the third is also null...
>
> The trick is to come up with language which recognizes that there
> can be any number of arguments. Personally, I think the existing
> language does a good job of that, and is pretty clear.
>
> > so I made this example that makes sense:
> >
> > COALESCE(column,substitute value)
>
> Perhaps a two-argument example would be helpful, as long as it
> doesn't mislead people into thinking the construct is limited to two
> arguments.
>
> -Kevin
>