Add new column in a select query

[ysrini]

Hi, i want to create a table B by using a select query on table A,


and also add a new column in table B initialized to ''

If i do
select T.*,'' AS new_col1 into B
from T;

The above works, but when i add data to table B, it fails with 'Numeric overflow' error, and i guess it's because the type of new_col1 is not defined
How do i defined new_col1 in the select query itself?

I guess it should be something like
select T.*,''(text(20)) AS new_col1 into B
from T;

but i couldn't figure out the correct syntax
Any help would be appreciated
Thanks
-srinivas

[llkhoutx]

select T.*,-1 as B from T 

or

select T.*,12/31/09 as B from T 

or

select T.*,"Dufus" as B from T 

or

select T.*,3.1416 as B from T 

[ysrini]

Thanks llkhoutx, but i want to initialize as '' (empty)
in the select statement itself

[llkhoutx]

select T.*,Null as B from T