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