Hmmm... perhaps the old arcane ways are up for revision...

Did a very tiny test in tempdb on a 2005 box, and it indeed looks like

alter table alter column collate actually seems to change the ascii values of data already stored in the column...

/Kenneth