>>>>I am selecting firstname + ' ' + lastname from SQL using SQLEXEC. The result column on Fox side is a memo field. Can it be a "C" type?
>>>>
>>>>Thanks
>>>
>>>Even if you get it as Memo, you can still show it in VFP grid (is this your purpose?) as Character.
>>Yes, I know, but I think I need to use an Edit box for that.
>
>PMFJI, but if this for display purpose only, you can just use left(myMemo,254) as a controlsource.
>
>But anyway, the point is mute, since Sergey's solution should work.
This point is not mute (and it's not even moot). As long as you need to show it only why should you burden SQL-Server with unnecessary datatype conversion? To be precise the most consistent way would be bringing real fields only (w/out concatenation) and then show them in a grid in the most suitable way.
Edward Pikman
Independent Consultant