Thank you for your concern :). I wish I could rest but I need to get my app from VFP to MS SQL server or I will be resting full time :).
>It's a statement not expression. You should get some rest on weekends not work. :)
>
>
>>I believe the expression below is what will work. Thank you.
>>
>>>
>>>That's not what your original update statement does. Try
>>>
>>>UPDATE mytable SET myfld1 = IIF(myfld1 > nValue1, myfld1 - nValue1, 0) + nValue2 WHERE Pk = nPkValue
>>>
>>>
>>>You'll have to replace IIF() with CASE in MS SQL Server
>>>
"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