Ah, took me a while to figure out what trimmean did.. (found the swedish translation)

But I think it's missing the trim percentage parameter, not? If I read the help correctly, the function should trim a given percentage of rows - half from top and half from bottom, and in any case, at least one row from top and one from bottom. This suggests that more than one row from top/bottom may be removed before the average is calculated depending on how high the trim-percentage is.. right?

Until we get support for SELECT TOP @var the only way I can write a function like this is by resorting to dynamic SQL...

/Kenneth