Change the Collation of a database field by query

This will be very needful when it's come to different language having in your web site / system
ALTER TABLE MyTable ALTER COLUMN CharCol
            varchar(10)COLLATE Latin1_General_CI_AS NOT NULL
GO