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

Select "Newfield" = Case When lCondition=1 Then 'Yes' Else 'No' End From Table1