Home Forums SQL Server 7,2000 T-SQL Modify WHERE clause in Stored Procedure RE: Modify WHERE clause in Stored Procedure
sokolove
Mr or Mrs. 500
Points: 546
More actions
December 21, 2004 at 7:15 am
#534607
I would use a case statement in your SP.
SELECT ID, TITLE FROM MyTable
WHERE
Closed_Date
CASE @Open
WHEN 0 THEN
Is Null
ELSE
IS NOT NULL
Edward M. Sokolove