Create 9.99 column with SQL query

[inoxo]

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

 

[MarkK]

SELECT ..., CDbl(0) as Amount, ...

 

[inoxo]

So simple ... and it works !
Thanks Lagbolt