Moving Access Queries to SQL Server

I am in the process of moving an access 2000 database to SQL Server. I was able to move the SQL code from most of the queries into SQL server and create views, but several of the queries have embedded VB statements (mostly iif statements or datepart function) and wouldn’t move over. What is the best way to recreate these in SQL Server so that I can get to them through my web site?