And I'm sure you know the core syntax...it's something like...

Alter table TableName Alter Column ColumnName uniqueidentifier

(Also, goes without saying, if SQL server can't translate the original character value to a uniqueidentifier, the statement will fail)