>How do I insert a blank column into a query of type numeric(10,2)?
>
>Instead of Amt below being 0, I want to be able to make it numeric(10,2).
>
>SELECT SPACE(20) as PO, 0 a Amt, nbalance from filea
>
>
>
>Thanks in advance


try this

SELECT  SPACE(20) as PO, 0000000.00 as Amt, nbalance from filea

hope this helps