Yes, it does return information if I run it in the query analyzer. I have tried both and In-Line Table-Valued function as well as a Multi-Statement Table-valued function. If the queries are ran in the analyzer the same result sets are displayed.

Kelly