>hi, i'm rewriting local views to remote sqlserver 2000 views. but i have a problem.
>
> IIF() statement must be replace by CASE WHEN condition1 THEN x ELSE y END.
>this CASE statement doesn't work and that causes error. how to write it ?


I have not problem with CASE WHEN END on MS SQL and Oracle.

And your code is?

MartinaJ