>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.