IF Cases In Where Clause

Question

Hi

can we use IF () in where clause more than 3

Thanks

Sandeep

---

Sandeep Kumar

Answer 1

No if clause.. but you can use CASE When..

vt

---

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Answer 2

You should use IIF() not IF. See this

http://msdn.microsoft.com/en-us/library/hh213574.aspx

---

Many Thanks & Best Regards, Hua Min

Answer 3

If you mean IIF() function of 2012,  it can be nested 10 levels, the same as underlying CASE.

http://msdn.microsoft.com/en-us/library/hh213574.aspx

---

Serg

Answer 4

If you mean IIF() function of 2012,  it can be nested 10 levels, the same as underlying CASE.

Stick to ANSI/ISO Standard CASE expressions and do not use hillbilly dialects. Experienced SQL programmers will laugh at you if you don't. 

---

--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL Programming Style / SQL Puzzles and Answers / Thinking in Sets / Trees and Hierarchies in SQL