Insert blank column into temp table

[jayfox]

How would I create a temp table where some of m columns I would like to leave blank heres what I tried but failed:
I would like to leave the name column blank:

drop table #test
create table #test
( id varchar (5),
name varchar (40),
contact varchar (30))
insert into #test
select customerid as id,
contactname as contact
from customers

 

[SQLSister]

Specify the columns you want to insert into in the insert statement.

Questions about posting. See faq183-874

 

[jayfox]

Thanks sqlsister