Default where clause

Is it possible to generate a standard where clause ?

If I have a table "Transact" with the fields Account, Date, Amount and Department, and the user makes a statement like:

select * from transact;

I would like to change it to:

select * from transact
where (department < 05 or department > 37);

without the user knowing anything about it.

Another user may get this:
select * from transact
where (department > 37 and account < "15000");

and so on.

--
Gorm Larsen Received on Fri Mar 19 1999 - 10:43:07 CST