What is the database engine on which this query will be runned?

Access recognize IIF but SQL Server needs a CASE.


>Is it possible for me to insert IIF function in SQL Statement.. for example:
>
>SELECT MONTHLYSALES.*, IIF(MONTHLYSALES.POINT gt=10, "Good", IIF(MONTHLYSALES.POINT gt=5 AND MONTHLYSALES.POINT lt 10, "Enough", "Bad")) as SALESPOINT FROM MONTHLYSALES ORDER BY SALESMANCODE
>
>(pls correct the above SQL statement if there's mistake)
>
>any idea would be greatly appreciated and many thanks in advance
>
>Regards
>Winan