• If you are sure it won't truncate any data then I would create a new table with the nvarchar column. Copy all the data from old table to new table make sure the records match up. Rename old table to a different name and then rename new table to old table name. Truncate old table and drop it.

    -------------------------------------------------
    Will C,
    MCITP 2008 Database Admin, Developer