>>I have a select statement that combines a number of fields, is it possible to specify the resulting field type?
>>
>>eg trans(nBinding)+mBinding can I force the resulting field to be a memo field.
>>
>>Thanks in anticipation
>>Caroline
>
>I did some additional tests, trying to force a memo with substr() or padr() - the usual error message is "string is too long to fit".
>
>I have the impression that you will simply have to use a non-SQL solution, for instance, copy all other fields to a cursor, include an empty memo field, and then apply a relation and a REPLACE.
>
>I suspect that in the meantime, you must already have done something similar.

Thanks Hilmar for all your help and testing. Yes I have been trying some similar solutions.