Romulus
06-19-2002, 12:15 PM
Specificallly, I want to reduce the field size for a number of fields. The values that are currently in the table will not exceed the field size I want to change it to, but I am wondering if it is possible that I will lose data if I reduce the size. I would rather not change the size if data will be lost.
Rakier
06-19-2002, 01:22 PM
I don't think that you will lose data as long as the current data does not violate any of the new rules that you add to the table structure. Specifically, if you change it from 50 characters to 10 and have no data longer than 10 characters in the field...you should be okay.
Of course...backup before you do anything!:)
Romulus
06-19-2002, 01:53 PM
Thanks Rakier! I'll give it a try.