• Willem,

    Thank you for your answer.

    Ad 1.

    I tried to change Text -> Varchar(max) in a copy of the database and found out the data are unchanged. So far so good.

    I have no indexes on the Text field, so there is no rebuilding of indexes is required.

    Ad 2.

    The client application reads and writes the Text field in a normal way (using AsString, not AsMemo or AsBlob) so I don't expect any problems.

    But I'll try the application in a test environment, to check for any problems.

    Thank you for your suggestions. 🙂