dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Beginner
Aug 31, 2005

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


Achieving IIF Functionality in T-SQL

The syntax for the IIF command in T-SQL is:

select 
case <condition>
when <value1> then <result1>
when <value2> then <result2>
....
else <result3>
end
from <table1>
In the following example, the bit data type will store either 0 or 1. Using the IIF query, a result is provided in a meaningful way as follows:

select case availability 
    when 0 then 'Not Available' 
    else 'Available' 
end 
from table1
Where availability is the field name in table1, datatype bit.
Jaya Nehru Kumar
 
Thanks for your registration, follow us on our social networks to keep up-to-date