>I'm converting a vfp local view to a reomte view against SQL Server 7, but I'm choking on some the VFP syntax:
>
>SELECT Doners.cid, Doners.firstname, Doners.lastname, Doners.city,;
> Doners.state, Doners.zip,;
> ALLTRIM(Doners.firstname)+SPACE(1)+;
> IIF(.NOT.EMPTY(Doners.middle),middle+"."+SPACE(1),"")+ ;
> ALLTRIM(Doners.lastname)+SPACE(1)+ALLTRIM(suffix) AS name ;
> FROM basie!doners;
> WHERE UPPER(Doners.firstname) LIKE UPPER(?vp_firstname);
> AND UPPER(Doners.lastname) LIKE UPPER(?vp_lastname);
> AND UPPER(Doners.city) LIKE UPPER(?vp_city);
> AND Doners.state LIKE ?vp_state;
> AND Doners.zip LIKE ?vp_zip;
> ORDER BY Doners.lastname, Doners.firstname
>
>The alltrim in easy, but I don't have a clue how to convert the IIF statements in my SQL. Any ideas?
It's called CASE statement in SQL-Server.
Edward Pikman
Independent Consultant