SQL Server's IIF:

CASE WHEN condition THEN value1 ELSE value2 END

SQL Server's ISNULL():

value1 IS NULL

ISNULL(x,y) can be done this way:

CASE WHEN x IS NULL THEN y ELSE x END

>i have tried to creat a remote view using iif() function but sqlserver doen't recognize this. how can i do it ? (i also tried it in sqlserver view designer but it was the same thing)
>
>another function have the same problem : isnull(x,y) sqlsqerver function. works well in sqlserver but doen't work with the remote view designer in vfp.
>
>i need informations to continue my work...