Is it possible for me to insert IIF function in SQL Statement.. for example:

SELECT MONTHLYSALES.*, IIF(MONTHLYSALES.POINT>=10, "Good", IIF(MONTHLYSALES.POINT >=5 AND MONTHLYSALES.POINT<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