>To avoid NULL values in my cursors, I use something like SELECT NVL(MyField,space(len(MyField))). From what I understand, the first record in a SELECT statement determines the field's width. Since memo fields are of varying length, how do I select a memo field without getting a possible NULL value? i.e. SELECT NVL(MyMemoField,space(???))
>
>Thanks
>Elyse

see my reply on MS newgroup

use a separate table with one memo field, one record

join that table to the other tables in the query, and refer to its memo field


Christian