SQL Server 2005：从WHERE子句调用存储过程

I need to make a SELECT with a call of a stored procedure in the WHERE clause. It should be something like that....I need to make a SELECT with a call of a stored