Achieving IIF Functionality in T-SQL

Achieving IIF Functionality in T-SQL

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

select case 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.


About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist