Russell,

You can wrap it with a new name.

create cursor x1 ( i1 i, i2 i, i3 i, i4 i )
insert into x1 values ( 1,2,3,4 )
insert into x1 values ( 2,3,4,5 )
select vfpmax( i1, i2, i3, i4 ) from x1
select max( vfpmax( i1, i2, i3, i4 ) ) from x1

function vfpmax( p1, p2, p3, p4 )
return max( p1, p2, p3, p4 )

>Is there a way to use the MAX function in a SQL statement (as opposed to the documented MAX "field function" that calculates the largest value in a column). To be more specific, for any particular record, I need to multiply the value in a field by the value in another field. However, the value in the first field will sometimes be negative 1 and in that case I don't want to multiply negative one by the value in the other field, I want to multiply 0 by the value in the other field.