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
>>