> Dear all,
>
> I have a query like this :
> ...
> select t.*,
> Coalesce(((t.data1 + t.data2) * (t.data3 - t.data4)), 0)
> as FINAL_VALUE
> from myTable t;
> ...

As a habit - I would recommend adopting NOT using the * in your selects.
Don't be lazy define the fields you want.
Secondly - you may want to create views for this select, then you can return
the field>100 clause.
Alan