>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?

IIF() - CASE (T-SQL)
NVL() - CASE and IS NULL - like if VFP version was IIF(ISNULL(cfield),"",cfield)

The SQL Books Online gives very good descriptions and examples of these.