use case in where clause sql server

case, sql, sql-server

Solution

you just need to add `END` keyword

SELECT * 
FROM    tableName
WHERE   dateCol =   CASE WHEN @considerDate =1
                         THEN @date 
                         ELSE dateCol 
                    END

Problem

what im trying to do is to make a query consider or not a datetime value so i dont have to do this in a stored procedure ``` if @considerDate =1 begin select * from table where dateCol = @date end else begin select * from table end ``` i would like to do somethink like ``` select * from table where dateCol = ( case when @date is not null then @date ) ``` In an single query

Original source