>>>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?

Not because the SQL Engine declare the column with the worst case