Subject Re: [firebird-support] sql question.
Author sugi
> As a habit - I would recommend adopting NOT using the * in your selects.
> Don't be lazy define the fields you want.
Understood. Bad Example. It was taken as-is from my prototype code and
the reason it's done this way is because the DB Design is still not
finished yet. I suppose it *is* 'laziness'...:)

> Secondly - you may want to create views for this select, then you can return
> the field>100 clause.
A view, ok. A bit difficult in my case, but workable. Thank you.
Would appreciate any other workaround to the problem.

TIA & Regards,