Danny Ocean (6/5/2013)
Good question ron.You write down in question that "Meaning IIF is not a function in SQL SERVER 2012? ". I think it should be "Meaning IIF is not a user define function in SQL SERVER 2012?". This line confuses.
Anyway thanks for question.:-)
Actually I was confused, if the question is about IFF or IIF. The question heading says "IFF" but the question is about "IIF" :hehe:
Verdict: "IFF" is nothing but a typographic error in the Qotd; contrary it is a short-hand notation for "IF and Only IF" used in mathematics (I do remember this from my high school days).
Anyways, nice question Ron!
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter