Dear Richard,

Strange but true!

I just noticed something at Time Index 5:20 in Video 4.
If i write an SQL command to say ALTER TABLE TempT ALTER COLUMN MiddleName CHAR(50).
It alters the table as expected. But it also alters the existing data!
I somehow noticed that i get extra spaces infront of the existing data. The total length of the records in this field now comes to 50! Kind of strange but its true.
To fix it, you have to either use the RTrim function or to say ALTER TABLE TempT ALTER COLUMN MiddleName TEXT. This would set it to the default 255 characters.

Give it a shot, you will be surprised.

MICAH

---

Reply from Richard Rost:

That's very strange. I haven't tested it myself (I will when I get some time) but ALWAYS be careful when updating table structure. I have also seen some weird things like this happen before.