Quote Originally Posted by RBARAER
You're right, it is more generic this way. Thanks for the improvement.

Are you sure you need the NVL on count(*) ? If there is no match the count will simply return 0, won't it ?

Regards,

rbaraer
Well I havn't tested it. I added NVL fearing that it would return "No Data found"