>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
>
>
>>
I didn't realize that I would get an error in VFP too. My problem with the SQL Server syntax is that my CASE expression will be very long. What I am trying to return is a difference between two DateTime fields in number of days but I find that sometimes it returns negative.
Thank you for your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham