Hi Bill,
thanks for testing the issue. Since the argument of the EVALUATE() function doesn't always contain the name of a character data field, there is a technical reason for using the TRANSFORM() function (see my answer to David).
I wonder if there was any setting unknown to me which creates this behaviour. One of the usual suspects: is it a bug or is it that way by design?
Robert
>A couple of quick tests seem to indicate it has to do with table Memo fields. Putting the data into a memory variable then issuing your TRANSFORM(EVALUATE()) statement worked fine but creating a cursor with a Memo, loading the data into it and issuing the TRANSFORM(EVALUATE()) truncated it to 256 chars. On the surface it would seem to be ( to me ) a bug. But as David mentioned, technically in your case you could probably get away w/o the TRANSFORM().
I've acquired quite a taste for a well-made mistake... [Fiona Apple]