Dean,

>select max(len(my_memo_field)) as nResult from myDBF.

Try this, max( 0000 + len( my_memo_field ) ), where 0000 is enough digits to be larger than the largest memo.