Thanks for both of these methods!

It works great now.

Torres~

Sorry Gail. It's a single Inline function with a subquery.

I assumed this was a common option with most udfs. Or not?

Thanks for the replies.

The udf is a Table-valued Function, returning a dataset.

I could add the RegionID as a parameter to the udf, but was wondering if that was necessary.

Thanks.

Torres