Can we use case in where clause in sql server - Expected Income 60 euro

Analysis of the search query	can we use case in where clause in sql server
Competition	Low
The average cost per click Adsense	0.9 €
The expected traffic per day	2
The expected traffic per month	60
Income per month	60 €

Top competitors on query "can we use case in where clause in sql server"

Difference between And clause along with on and Where clause when used with left join in SQL Server - CodeProject
  http://www.codeproject.com/Articles/231132/Difference-between-And-clause-along-with-on-and-Wh  Competition: low
Suppose we have two tables Departments (deptId, deptName) and Employees (empID, DeptID, EmpName, Salary) and deptiD is the foreign key of the department table. When the On clause is used in an outer join, the outer table will have no effect on this On clause and all rows from the outer table will be returned and the On clause determines which rows of the subordinate table joins to the outer table

  http://www.craigsmullins.com/ssu_0899.htm  Competition: low
Mullins CASE expressions are often over-looked but can be extremely useful to change very complex query requirements into simpler, and sometimes more efficient SQL statements. It provides a quick way of transforming normalized data structures into the more common denormalized formats that most business users are accustomed to viewing on reports

sql - How can I use a CASE statement in a WHERE clause with IS NULL? - Stack Overflow
  http://stackoverflow.com/questions/6867917/how-can-i-use-a-case-statement-in-a-where-clause-with-is-null  Competition: low
notation, or you can use CASE WHEN expr THEN ..., but your simple CASE WHEN NULL THEN notation will never evaluate the THEN because NULL will always evaluate to UNKNOWN, not TRUE