Hi @Dan Pasco 

This greatly helps my understanding. It would be nice if this information formed part of the documentation for Cache itself and could be elaborated upon.

Essentially to use SELECT, function must implement Table-Valued Function (TVF) interface. Is there any specific documentation relative to TVF you are able to point me towards please?