>When I do a query ... lets say, "SELECT MAX(COST) AS COST, INVNO FROM INVOICES" ... what do I know about the value of INVNO in the result set? ENGINEBEHAVIOR is 70. In all the testing I have done, it always SEEMS to return the value from the record containing the MAX() value. However, I don't KNOW any specifics about the code that performs the fetch, so I don't know whether this is a reliable observation or not.
>
>Does anyone have any specific info regarding this?
>
>Regards
>
>Art

It depends how this SELECT continues, if you have:
SELECT MAX(COST) AS COST, INVNO FROM INVOICES GROUP BY InvNo
then you always will get MAX(cost) for some specific invoice #. But if you didn't have such grouping you can't expect always to get right record, sometimes you'll get InvNo where the MAX(Cost) is, sometimes you will not, so you can't rely on this. Better change this to:

SELECT COST, INVNO FROM INVOICES WHERE Cost = (SELECT MAX(Cost) FROM Invoices) ...