|
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?
>
Navigation:
[Reply to this message]
|