How do I add a NULL column when SELECT'ing INTO a new table?

Question

I have a statement like this:

SELECT field1, field2, MyField = NULL
INTO NewTable
FROM OldTable

This does what I want with one exception: the field I created MyField and filled with NULL is an INT type and I'd like it to be a VARCHAR type. I don't know how to modify the same statement to create the new field with the VARCHAR type.

Thanks.

Answer 1

Try replacing the null with

CAST(null as VARCHAR)

Answer 2

SELECT field1, field2, convert(varchar, NULL) as MyField
INTO NewTable
FROM OldTable