Not all SQL functions work

[somethingsimil]

MIN() MAX() do not seem to work at all, and I've noticed many other examples, as well as some unexpected behavior from the NVL() function.

In a previous comment, you mentioned this MSDN resource for functions.

Is this the correct reference guide of available functions? ...because many of these aren't recognized.

[Admin]

MIN() and MAX() functions work perfectly, as well as NVL(). List of supported functions available here.

[somethingsimil]

Perhaps it's not supported in the select block? Here is the SQL I'm using...

select ico, MAX(paid, reserve) amount
from "E:\Reporting\CLAIM.DBF"
group by ico

...with an error message: -> Function name is missing )

Even a simplified version:

select MAX(paid, reserve) total
from "E:\Reporting\CLAIM.DBF"

...gives the same error message. Am I missing something?

[somethingsimil]

Actually, I think I realized my error. I was using max without as an aggregate function. I should have had...

select ico, sum(MAX(paid, reserve))
from "E:\Reporting\CLAIM.DBF"
group by ico

That error message (which I'm guessing is from FoxPro) is not very intuitive.