>>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?
>
>Try to limit the lenghth of the value returned.
>
>CAST(firstname + ' ' + lastname AS char(50))
>
Well, I am trimming both columns on SQL side:
select *, rtrim([first name]) + ' ' + rtrim([last name]) as fullname
still not good enough?