If statement in SQL Server 2

[Cheveliar]

Ratio: IIf([dmat_w_3set]+[dmat_l_3set]=0,0,([dmat_w_3set])/([dmat_w_3set]+[dmat_l_3set]))

I used this in access and now I want to traslate it to SQL but the If statement is not the same contruct and I can not find it anywhere. Any help would be appreciated.

 

[MakeItSo]

SELECT IIf([dmat_w_3set]+[dmat_l_3set]=0,0,([dmat_w_3set])/([dmat_w_3set]+[dmat_l_3set])) as Ratio
...

According to my SQLServer manual, the IIF function should be of the same syntax as in Access. Switch to SQL view in your Access query. There you have (in this case) the correct syntax.

 

[LFCfan]

It's CASE you need:

SELECT CASE <expression1>
   WHEN 0 THEN <expression2> 
   WHEN 1 THEN <expression3>
   ELSE <expression4>
   END

ie when <expression1> evaluates to zero, <expression2> is selected, etc

 

[JamesLean]

There's no such thing as IIf in T-SQL. Use a CASE expression:

SELECT CASE WHEN [dmat_w_3set] + [dmat_l_3set] = 0 THEN 0 ELSE [dmat_w_3set] / ([dmat_w_3set] + [dmat_l_3set]) END AS Ratio

--James