Equivilant if IIf(Expression, true, false) Access function

D

Daryl

Hi
I have several MS Access queries that contain Immediate If (IIF) functions
in their SELECT clauses. I was wondering if I could get some tips on how
these can be converted to T-SQL ie used in a procedure.

thanks
daryl
 
S

Steve Jorgensen

Hi
I have several MS Access queries that contain Immediate If (IIF) functions
in their SELECT clauses. I was wondering if I could get some tips on how
these can be converted to T-SQL ie used in a procedure.

thanks
daryl
Click to expand...

CASE WHEN <expression> THEN <truepart> ELSE <falsepart> END
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using IF logic in a calculated field 2
IIF in Crosstab Expression 0
iif statement what is wrong with this expression 2
MS ACCESS query returns empty recordset from odbc linked sql server tables 3
SQL issue with "either true or false" 0
Report is slow for non administrator Access 2007 1
can max() be used within IIf() function in MS Access 1
IIF function with * 7

Top