Thanks to all for the great advice!

Ian's assumption about my requirements for the query were correct - his answer was what I was looking for (sorry for not explaining myself...

Right!

Thanks again!

Thank you, Peter!

Works like a charm, although I did have to modify it slightly to compensate for the fact there are some customers in my actual list who have only...

The purpose of the udf was to take a person's name, stored in separate fields, and concatenate it into one field in the format [Last Name] [Suffix], [Prefix] [First Name]...

Thanks for the quick reply, Jeff.

I was able to track down the cause... I forgot to mention that one of the select fields is derived using a udf (it takes...