>

>SELECT tmpShops.*, shopques.*, ;
>      IIF(ISNULL(shopextr.extratitle), "", shopextr.extratitle) AS extratitle, ;
>      IIF(ISNULL(shopextr.extratext), "", shopextr.extratext) AS extratext ;
>   FROM  tmpShops, shopques LEFT OUTER JOIN shopextr ;
>      ON  Shopques.shopquesid = shopextr.shopquesid ;
>   WHERE (shopques.shopid = tmpShops.shopid) ;
>      AND (shopques.shopid IN (SELECT shopid ;
>                                  FROM tmpShops)) ;
>   INTO CURSOR tmpExport ;
>UNION ;
>   SELECT tmpShops.*, cursques.*, ;
>         IIF(ISNULL(cursextr.extratitle), "", cursextr.extratitle) AS extratitle, ;
>         IIF(ISNULL(cursextr.extratext), "", cursextr.extratext) AS extratext ;
>      FROM  tmpShops, cursques LEFT OUTER JOIN cursextr ;
>         ON  cursques.shopquesid = cursextr.shopquesid ;
>      WHERE (cursques.shopid = tmpShops.shopid) ;
>         AND (cursques.shopid IN (SELECT shopid ;
>                                    FROM tmpShops))
>
>

>
>I thought the problem was with the ISNULL statement, but it looks like I am
>wrong. What confuses my is that if I just let FoxPro put the .null. in the
>memo fields the UNION will work fine. But when I try to stop the .null. it
>gives me the error I listed above.

I have a thought -- instead of assigning "" when there's a null, assign an empty memo field. IOW,

CREATE CURSOR myCurs (myMemo M)
SELECT... ;
   IIF(ISNULL(shopextr.extratitle), myCurs.myMemo, shopextr.extratitle) AS extratitle

or

SELECT... ;
   NVL(shopExtr.extraTitle, myCurs.myMemo) AS extraTitle