|Subject||RE: [firebird-support] sql question.|
> Dear all,As a habit - I would recommend adopting NOT using the * in your selects.
> I have a query like this :
> select t.*,
> Coalesce(((t.data1 + t.data2) * (t.data3 - t.data4)), 0)
> as FINAL_VALUE
> from myTable t;
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.