>Thanks. That problem is solved. What about replacing a character field with a memo field?
As long as it is Character to Memo, you can do this
ALTER TABLE mytable ALTER COLUMN memo C(25)
If you try it going from Memo to Character, you will lose your data.
Michael Helms
May the Schwartz be with you.<(©¿©)> -- Mel Brooks
"Someday, and that day may never come, you will be called upon to perform a service" -- Vito Corleone
"Live like there is no tomorrow, Dance like no one is watching, Love like you've never been hurt." -- Anonymous
"I'm thinking about joining the campaign for shorter tag lines." -- Me