Home Forums SQL Server 7,2000 T-SQL Modify WHERE clause in Stored Procedure RE: Modify WHERE clause in Stored Procedure

  • 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