Hi All I'm new SQL Been using Access for a number of years. I wanted to know how to convert a Iff Statements into SQL.

My Iff Statement

DAYRATER: IIf([EmployeeTypeId]=12 Or [EmployeeTypeId]=10,([SumOfbillable_hours]/9),"NA")

If any one can point me in the right direction that would be great.

Many Thanks

Scott

You can use the CASE statement for this:

CASE WHEN [EmployeeTypeID] IN (10, 12) THEN [SumOfBillable_Hours] / 9,
     ELSE 'NA' END

Just make sure that the data type that will be returned for both cases are compatible to each other. Otherwise you will get an error message.

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp