<div>
Nope, the closest you can come to conditional expression is in the use of the where and having clauses on your select statements, or use of IF/Else, Case, When/Then expressions.<br />
<br />
Your best source for info if you have installed SQL Server client utilites is in SQL Server Books online, assuming you had enough space to install those as well.<br />

</div>


Nope, the closest you can come to conditional expression is in the use of the where and having clauses on your select statements, or use of IF/Else, Case, When/Then expressions.

Your best source for info if you have installed SQL Server client utilites is in SQL Server Books online, assuming you had enough space to install those as well.


<div>
This is not what we are looking for.<br />
We need to use the equivalent function of IIF(MS- Access2.0)<br />
&nbsp;in MS-Sql Statements.<br />
<br />
Like for eg. DECODE function in oracle.<br />
<br />
select decode(a.field1&gt;30,a.field<wbr />2,decode(a<wbr />.field1&lt;20<wbr />,a.field3,<wbr />a.field4))<wbr /><br />
from table1 a<br />
where &lt;condition&gt;<br />

</div>


This is not what we are looking for.
We need to use the equivalent function of IIF(MS- Access2.0)
 in MS-Sql Statements.

Like for eg. DECODE function in oracle.

select decode(a.field1>30,a.field2,decode(a.field1<20,a.field3,a.field4))
from table1 a
where <condition>


<div>
good. I am able to solve the problem thru the answer u gave me. Thanks a lot.<br />

</div>


good. I am able to solve the problem thru the answer u gave me. Thanks a lot.


<div>
<div class="content wysiwyg-content">
In Access there is a function called Immediate If ( IIF) which has the same functionality as ternary operation (?:) in C. I want to know whether there is a similar function in SQL Server.
</div>
</div>


In Access there is a function called Immediate If ( IIF) which has the same functionality as ternary operation (?:) in C. I want to know whether there is a similar function in SQL Server.

Is Immediate If available in Sql Server ?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.