Filtering any SELECT statement against a table (SQL Server 2008)

Have a need to filter any and all SELECT statements against a particular table in a SQL Server 2008 database. Basically need to add an an additional condition (or create one) to all SELECTS.

So the server receives a request for SELECT * FROM PRODUCTS, we need to change this to

SELECT * FROM 开发者_如何学GoPRODUCTS WHERE Condition = 1

I'm open to just about any solution, anyone have any thoughts on how to achieve this?

• Not our program, this would be a modification to an ERP package at the database level.
• Embedded CLR is an available option, if it helps