Ok, thank you very much Paul.

Walter.

On Sat, Apr 9, 2011 at 6:19 PM, Paul Vinkenoog <paul@...> wrote:

>
>
> Hi Walter,
>
> > Is possible to use COALESCE in the following way ?
> >
> > SELECT COALESCE(SELECT ...... , PRD_COUNT)
>
> Yes, but you need a pair of parentheses around the inner SELECT:
>
> SELECT COALESCE((SELECT ... FROM ...), PRD_COUNT) FROM ...
>
> HTH,
> Paul Vinkenoog
>
>


[Non-text portions of this message have been removed]