In Access 2000 you can execute a query like

SELECT IIF([cyCompany]= '<No Company>',[HomeStreet],[CyBusinessStreet]) AS BusinessHomeStreet
FROM Companies

but in SQL Server 2000 it generates a problem. Does SQL Server 2000 supports this command and if no what's the best workaround?