How can we change the data type of a column of a table in SQL?

Question

how we can retrieve the unique values for the in a table without using the DISTINCT keyword

Answer 1

alter table TableName
alter column ColumnName nvarchar(200) [null | not null]