Sorry Gerry,

>>There can be situations where a UDF can simplify what would otherwise be a very complex query.

>>If it looks like a UDF has merit, one tests it with a representative data set; if it performs satisfactorily (considering the alternatives), then one incorporates it.

I've never seen a situation where I couldn't come up with a set of SQL queries (i.e. the base query and a subsequent SELECT or UPDATE) that didn't out perform a UDF in a SQL statement. I not a fan of absolute statements, but in my experience with Fox, this one stands.

I'd be interested in seeing any examples of a UDF in a SQL SELECT that *is* fast.

Regards,
Thom C.