When we upsized our regular Foxpro database to SQL Server, many of our views had IIF()'s and NVL() statements. I've been unable to get anything to do these functions in the remote views to the new SQL Server database. Anybody else encountered and overcome this?