>Sooooo close. I got excited for a second. Two problems:
>
>1. The work area in this data session is kind of used as the "base". By that I mean that many programs "SELECT Table>" to put them back in a consistent work area. Most of this has been weeded out over the past few years, but there are still quite a few places that "land" back at this table.
>
>2. I some cases, the memo field exceeds 16 MB. When using Scatter Name, it truncates the value to 16 MB. I even tried using CAST to explicitly make it a Memo data type after the fact and then reset the value, but that didn't work either.
1) is not a problem. Anytime you could use again to restore alias.
2) still not a reason to use a cursor and do many replaces. There are lowlevel functions.
Anyway you know your case better than anybody else.
Cetin