You'll get error in VFP as well because SQL MAX() has only one parameter. The MAX() in procedural code, that you're referring to, is totally different function.
* VFP
select IIF(FLD1 - FLD2 < 0, 0, FLD1 - FLD2) as NEWCOLUMN from MyTable
select CASE WHEN FLD1 - FLD2 < 0 THEN 0 ELSE FLD1 - FLD2 END as NEWCOLUMN from MyTable
>
>What is an equivalent of VFP MAX() function in SQL Server? For example, if I want to return a value no less than 0 (zero) I use the following in VFP:
>
>
>select MAX(0, FLD1 - FLD2) as NEWCOLUMN from MyTable
>
>
>But when using the above syntax with SQL Server I get error that MAX takes only one argument.
>
>I would appreciate some help.
--sb--