Does anyone know if there is a SQL Server function which is like IIF() in VFP? I want to do a select statment like the following...

SQLEXEC(1,"select iif(lCondition,'Yes','No') from Table")

Thanks,