Excellent
Thanks a mil
ben

"Jeff Cook" <jeffc@aspect.co.nz> wrote in message
news:2DAFAB4E-ECAC-4CEA-952B-CFB5D07028CD@news.elevatesoft.com...
>
>
> --
> Jeff Cook
> Aspect Systems Ltd
> www.aspect.co.nz
>
> "Ben" <arrow1432@verizon.net> wrote in message
> news:11FDF902-17F0-4A0D-972C-2BD20C9873F8@news.elevatesoft.com...
>> Is there anyway to write code like this:
>>
>> update PRWorkSheet
>> set XFica = 0.00 where SalaryOT is null,
>>  set xwht = 0.00 where SalaryReg is NULL
>>
>> The above code as is returns an error
>>
>
> Ben
>
> Try
>
> UPDATE PRWorkSheet
>     SET XFica = IFNULL(XFica THEN 0.00 ELSE XFica),
>            xwht =  IFNULL(SalaryReg THEN 0.00 ELSE xwht)
>
> Cheers
>
> Jeff
>
>
>
>