Help on SQL Statement

[SANCHIT SHARMA]

we are executing the following sql statement succesfully in MS Access
SELECT DISTINCT LS_ATTO.ATTODescription AS UserName, LS_ATTO.ATTOID AS UserId,
IIf(PASSWD.Supervisor=0,3,PASSWD.SUPERVISOR) AS Supervisor
FROM LS_ATTO LEFT JOIN Passwd ON LS_ATTO.UserID = Passwd.UserID
WHERE (((LS_ATTO.LogicalDelete)=0 Or (LS_ATTO.LogicalDelete) Is Null))
ORDER BY 1;

The same when we are using to create view in SQL 2005 it shows error
at

IIf(PASSWD.Supervisor=0,3,PASSWD.SUPERVISOR) AS Supervisor

is there any equvalent of IIF in SQL 2005 , pls help

Regards

 

[TechGnome]

It's the CASE statement....
In your case it would look like this:

CASE PASSWD.Supervisor
   WHEN 0 THEN 3
   ELSE PASSWD.Supervisor
END AS Supervisor

-tg

 

[SANCHIT SHARMA]

Thanks a lot, for your help. Its working fine.

Thx.