It's not clear what the problem is or what you're trying to acomplish.
Anyway, VFP will create a memo field if the size of the field returned is more or equal CURSORGETPROP("UseMemoSize") (default 255).
>I would like to do the following from VFP as an SQL Pass Through
>
SELECT CAST('Opening Balance' AS BLOB SUB_TYPE 0) AS mNarration from MACCOUNTS
>
>Please advise what I am doing wrong.
>
>The reason for this is that I have unknown lengths of string for this field and would like to bring it in as Memo field in VFP.
--sb--