The syntax for the IIF command in T-SQL is:
when then when then ....else endfrom
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.