Hi,
I made a SQL query which creates a new column and initialize it to 0.00 :
SELECT ... , 0.00 as Amount, ... INTO ... ;
This is within a procedure. Once running, the column is created in the table BUT with Long integer format. I would like to create the column with Double format so I can store later numbers with 2 decimals.
How could I do to force Double format for the new column when I create it with my SQL ?
Thanks in advance,
ixo
I made a SQL query which creates a new column and initialize it to 0.00 :
SELECT ... , 0.00 as Amount, ... INTO ... ;
This is within a procedure. Once running, the column is created in the table BUT with Long integer format. I would like to create the column with Double format so I can store later numbers with 2 decimals.
How could I do to force Double format for the new column when I create it with my SQL ?
Thanks in advance,
ixo