I **think** I saw a message where the person got around it using a UNION.
I think they fist has a dummy table much like Hilmar suggests but with ALL relevant fields defined, then did the select on that first using the AS clause on the memo field to give it a name, then UNIONed the real query with the memo field also having the AS < same-name> clause used.
good luck
>Unfortunately not !
>
>>>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
>>
>>You might try specifying an empty memo field as the first part of the expression, but I don't know whether it works:
>>
>>
>>create dummy (dummy M)
>>select ... dummy.dummy + trans(nBinding) + mBinding)...
>>
>>
>>HTH,
>>
>>Hilmar.