>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)