Posted by Hugo Kornelis on 11/07/07 22:27

On Wed, 07 Nov 2007 06:48:09 -0800, amj1020 wrote:

>I have three fields date, low, high. I need to calculate the midpoint
>of low and high and display it.

Hi amj1020,

SELECT "date", (low + high) / 2.0 AS midpoint
FROM YourTable;

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

[Back to original message]