Hello All,

I have an SQL statement that LEFT joins two tables. When the table are joined a .null. is placed in fields where there was no data in the second table. One of those fields is a memo field. What I am trying to do is prevent the .null. from being placed in the memo field. Here is the code I am trying. The field extratext is the memo field.

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

When I try to execute the SQl statement a get a "Operation invalid for a Memo, ..." error. Can anyone help me?

Thanks.

Chris