Posted by MC on 03/09/06 11:17

Or perhaps something like:

Update a
Set X= case when columnc=0 then 0 else column b/column c end




MC

"yangyang" <loveflying000@gmail.com> wrote in message
news:1141834929.055768.75450@v46g2000cwv.googlegroups.com...
> IF like this:
> Update a
> Set X=column b/column c
> where Column c<>0
>
> Update a
> Set X=0
> where Column c=0
>
> any help to you?
>

[Back to original message]