I need to write a similiar SQL query on a SQL server.

This query determines if the "Weekday" = Monday. If it does then the DayImport result = MONDAY if it equals something other than 2 it supplies a result of OTHER. This was written in Access97 and works great. I am trying to convert my application to SQL server and can't figure this one out.

SELECT tMaster.DT_Import, IIf(Weekday([dt_import])=2,"MONDAY","OTHER") AS DayImport
FROM tMaster;

Can it be done?