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

  • Thread starter Thread starter Daryl
  • Start date Start date
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
 
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
 
Back
Top