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

Question

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.

Answer 1

You'll want this.

CREATE VIEW VIEW2
AS SELECT [Column1],
cast(NULL as varchar(10)) AS column2
FROM VIEW1;