>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

What version of VFP are you using? You can use ISNULL() on memo fields. Some things you can't do (which I don't see you doing) are:

1. Index on memo field
2. Join on memo field
3. Group by memo field