>To make sure your new character field is long enough, type the following in the command window:
>
>SELECT MAX(LEN(ALLTRIM(MyMemoField))) AS length FROM MyTable
>
>This will give you the length of the longest memo field data string in your table and you can create your character field to be at least that long.
>
>HTH
Hi Brayn... thanks for the code... my longest MEMO field is 433..
I guess that is too long?
rob