Rudy and Anthony both suggested ways to try to get the 95% percentile >> SELECT AVG(score) >> FROM ( SELECT TOP 95 PERCENT WITH TIES score >> FROM dbo.TestScores >> ORDER >> BY score DESC >> ) AS Top95PercentAvg Hi Guys! Very nice. Big thanks! Yeah, I knew subquery was the way to go, but I wasn't sure about the syntax. And the little googling I did was leading me on a merry chase through the NTILE() command and the 'over' clause. Ick. There is a little trickiness though. For measures where 'larger' is 'better', I think you may have to take the top 95% records *ascending* ... and then grab the *max* value from that set. I believe that should give you the value for the 95% percentile. Thanks Much! RonL.