median function

I have a long term need for a median function, I was wondering if anyone has or knows of some code or user defined functions somewhere that would do this. Ideally you could use it just liket the rest of the aggregate functions like AVG, etc.Hi Bill

You would need some sort of CLR code to use it like AVG etc.

The SQL in the link below works (I translated it into Access SQL recently) however you will need to make minor modifications to account for nulls, not use the financial median etc.
http://www.oreilly.com/catalog/transqlcook/chapter/ch08.html

HTHsql