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.

you want to change in table ? Sorry I really dont understand your problem — usman allam, Aug 15 '13 at 15:41

Jonny · Answer 1 · 2016-08-17T16:56:10.623

11

Try replacing the null with

CAST(null as VARCHAR)

edited Aug 17 '16 at 16:56

answered Aug 15 '13 at 15:43

Jonny

2,509
23
42

4

Make sure that also specify the SIZE of the field. `CAST(NULL as VarChar(20))` replacing 20 with the appropriate size. – Declan_K Aug 15 '13 at 15:44

Luis LL · Answer 2 · 2013-08-15T15:50:25.637

2

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

edited Aug 15 '13 at 15:50

answered Aug 15 '13 at 15:44

Luis LL

2,912
2
19
21

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

2 Answers2