DBCC PAGE output after running the ALTER TABLE command:

Slot 0 Column 1 Offset 0x4 Length 4 Length (physical) 4

i = 1

Slot 0 Column 2 Offset 0x19 Length 8 Length (physical) 8

y = 200.00

Slot 0 Column 67108865 Offset 0x8 Length 0 Length (physical) 10

DROPPED = NULL

Slot 0 Column 3 Offset 0x8 Length 5 Length (physical) 5

z = 200.08

Column 2 is the CHAR(10) version of z - dropped.

Column 3 is the DECIMAL version of z.

Test ran on SQL Server 2008 10.0.2757

Paul