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

You have this information already. Both questions was answered in the last couple threads you started: Re: Upsizing to sqlserver problems Message #1246046 and Re: Is it possible to modify views's sql by code ? Message #1246627