Re: SQL clause to check value

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

My bad, I thought you were updating the file for later use.

For a query, the same thing works, though:

SELECT MAX(AMOUNT, 0) AS DEBIT, MIN(AMOUNT,0) AS CREDIT

Sorry about the confusion...

Joe
> Piece of cake.
>
> UPDATE MYFILE SET
>    DEBIT = MAX(AMOUNT,0),
>    CREDIT = MIN(AMOUNT,0)
>
> Your amount field is still intact, but your two new fields have either 
> zero or the appropriate amount (plus or minus).
>
> Joe
>