My alternate solution before anyone else responded was to resort to the use of IIF(). IIF( x > y, y, x ) as MyVal.

I just thought it was strange and was I missing something but completely went blank that SQL had its own version of the min/max commands.

>>I am having a problem with a simple select statement and don't know if it is a bug... To verify the simplicity of it, I created a bogus table with two numeric columns N1, N2 both integer.
>>
>>Then I issued
>>
>>select min( N1, N2 ) as tmpfld from tmptable.
>>
>>The error I received was
>>"Function name is missing ),"
>>
>>anyone seen this???
>
>The problem is that the MAX and MIN VFP functions conflict with the SQL ones... I think there is no solution (other than writing an UDF which does the same job) and would like to here about one, if available.