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.
Digg
del.icio.us
Newvine
furl
StumbleUpon
BlinkList
Newsvine
Magnolia
Facebook
Tailrank
Slashdot
Technorati
Google Bookmarks
Yahoo Favorites
Windows Live
Ask
