My SQL statement goes something like this:
SELECT MAX(mycolumn)
FROM MyTable
WHERE ThisValue=ThatValue
In this case, "mycolumn" is a FLOAT data type.
There are four rows with the following values:
6.0
6.25
6.25
6.25
My select statement returns only: "6.0"
I tried changing one of the values to "7.0"
But all I get, still, is "6.0" on the return.
I'm using SQL Server.
Any suggestions as to why I'm not getting the correct Max() value?
H.
Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
