• Thanks for this, it's a good clear summary of these features.

    Are there any performance gains to be had by switching to use these features over unioning a set of SQL statements together? If so I have a few reports that might benefit from rewriting to use them.

    Barney