iif help

[OhioSteve]

In Access, a logical function called "iif()" exists. It follows the pattern iif(test,a,b). The test is a boolean test. If the test is true, the function returns a. Otherwise, it returns b.

The same thing exists in Excel, only its called "If()".

I tried to use this in SQL Server and got an error. What syntax should I use?

 

[ClaireHCM]

You can modify the following query for boolean test


if (select a from mytable ) > 10
select a
else
select b

 

[SQLBill]

You can also use CASE. Refer to the BOL, use the INDEX tab and enter CASE. Also, check out the FAQs in this forum and also do a search on CASE.

-SQLBill