Q:

Create a new column in a view and assign it a data type

here is my query:
CREATE VIEW VIEW2
AS SELECT [Column1],
(NULL) AS column2 VARCHAR(10)
FROM VIEW1;

I get an error in the third line.
If I leave the query like this, without specifying the data type for Column2, the query works, but the default data type will be int, whereas I want to have VARCHAR. 
CREATE VIEW VIEW2
AS SELECT [Column1],
(NULL) AS column2 
FROM VIEW1;

Can you please help? Thank you!
Note: Only Column1 is in VIEW1. Column2 is NOT in VIEW1, it's a generated column with NULL values. 

A:

You'll want this.
CREATE VIEW VIEW2
AS SELECT [Column1],
cast(NULL as varchar(10)) AS column2
FROM VIEW1;

