>>I think so. It get zero but keep field type, becuase if you put: 0 AS Savings you will get an integer field, not float or money.
>
>With '0 AS Savings' you'll get Numeric field N(1,0). Not only type but size of the field (including DP) will be lost.
Yes, my mistake :-(
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.