>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
How about:
SELECT MAX(LEN(ALLTRIM(MyMemoField))) AS maxlen INTO CURSOR memolen
lnMaxLen = memolen.maxlen
USE IN memolen
SELECT NVL(MyMemoField, SPACE(lnMaxLen)) ...
HTH