Subject Re: CASE and SQL
Author Michael Vilhelmsen
Thank you


This helped some...

BUT

Is it not posible to use a parameter after the WHEN clause ?
Like this:

Update Table set
F1 = :PF1,
F2 = (Case When (F1=0) then
(:PF1 * F3)
else
(:PF1 * (F2 / F1))
end)


The above doesn't seem to work...

Michael