John, you can use

SELECT MAX(NFIELD) AS COLUMN1 FROM DATATABLE

Drop the second parameter to MAX()/MIN()


>Is this behaviour intentional?
>
>A table exists called DATATABLE and a numeric field NFIELD exists in it. The record pointer is on, say, record #1.
>
>?MAX(NFIELD, 99)
>SELECT MAX(NFIELD, 99) AS COLUMN1 FROM DATATABLE
>
>The first line works fine.
>The second line raises Error 1300 "Function name is missing )."
>
>MIN gives the same error. A pity.
>(I think this has been there since Fox 2xx - any comments?)
>
>Anyone else seen this?
>
>John Burton