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

sql select null field select-into
Baub picture Baub · Aug 15, 2013 · Viewed 8.3k times · Source

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

Jonny picture Jonny · Aug 15, 2013

Try replacing the null with 

CAST(null as VARCHAR)

Related questions

Return a value if no record is found

I have this simple statement that works: SELECT idnumber FROM dbo.database WHERE number = '9823474' If the number does not exist anywhere in the table, it fails. I would like to add something to this statement that says: IF …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
SQL SELECT WHERE field contains words

I need a select which would return results like this: SELECT * FROM MyTable WHERE Column1 CONTAINS 'word1 word2 word3' And I need all results, i.e. this includes strings with 'word2 word3 word1' or 'word1 word3 word2' …

Read More