> 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,
sugi.