>Hi to all, I'm trying to create a remote view in SQL Server, this is my SELECT
>
>

>SELECT Domicilios.idDomicilio, LTRIM(Domicilios.bairro) AS colonia,;
>  LTRIM(Individuo.nome_individuo) AS nombre, Domicilios.idCidade,;
>  Cidade.descricao AS ciudad,;
>  LTRIM(Domicilios.logradouro) AS direccion;
> FROM ;
>     dbo.Domicilios Domicilios ;
>    INNER JOIN dbo.Cidade Cidade ;
>   ON  Domicilios.idCidade = Cidade.idCidade ;
>    INNER JOIN dbo.Paineis_Domicilios Paineis_domicilios ;
>   ON  Domicilios.idDomicilio = Paineis_domicilios.idDomicilio ;
>    INNER JOIN dbo.Individuo Individuo ;
>   ON  Domicilios.idDomicilio = Individuo.idDomicilio;
> WHERE ( ( (  LEFT(Domicilios.iddomicilio,1) = ( ?Codigo_Pais );
>   AND  Paineis_domicilios.Causa_Saida IS NULL );
>   AND  Individuo.idIndividuo = ( 1 ) );
>   AND  IIF(IsEmpty(?cCodigo_Ciudad),Domicilios.idCidade!="99999999",Domicilios.idCidade = ( ?cCodigo_Ciudad )) );
>   AND  Domicilios.Bairro LIKE ( ?cNombre_colonia );
> ORDER BY 3, Domicilios.idDomicilio
>

>
>But I keep getting errors from the SQL ODBC Driver. I use to create Local Views using IIF() in the where Clause without problem, why I can't in a Remote View?.
>Thanks
>Luis Navas

Luis,
AFAIK neither IIF() nor ISEMPTY() are supported by SQL server (excluding analysis services).
For ISEMPTY: It'd be "" (0 length string or null (if allowed)
For IIF check case, coalesce, if..else
Cetin