Hi All,

I work with Visual Foxpro. I have to use Dynamic Where Clause in my SQL Server queries.

I found two options on the threads :
1) SELECT * FROM Table WHERE (SELECT CASE ...) = (SELECT CASE ...)
2) DECLARE @SqlStatement varchar(4000)
SET @SqlStatement = 'Sql Statement'
EXEC (@SqlStatement)

I'd like to know which option offer better performance.
Or is there other options ?

Thanks for your help.