Convert IIF to SQL 1

[AshleyRickards]

Can anyone help convert the IIF statement below to SQL.
Thanks much.

SELECT dbo_points.REC_ID, dbo_points.AB_93, dbo_points.AB_93Rev, dbo_points.AB_93RevAmount, IIf([AB_93Rev]=-1,[AB_93RevAmount],[AB_93]) AS AB_93X
FROM dbo_points;

Ashley L Rickards
SQL DBA

 

[tlbroadbent]

Use a CASE statement.

SELECT
REC_ID,
AB_93,
AB_93Rev,
AB_93RevAmount,
Case
When AB_93Rev=-1 Then AB_93RevAmount
Else AB_93
End AS AB_93X
FROM dbo_points
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[AshleyRickards]

Thanks Terry. Ashley L Rickards
SQL DBA