Decimal data type in static SQL or DataWindow

PowerServer will return numeric data with a fixed decimal point length according to the decimal precision of the column. If the decimal place is insufficient, zero will be automatically filled; while PowerBuilder will not fill zero after the decimal point of decimal data. For example, the money-type data may display as an integer (for example, 40) in PowerBuilder; while display as a floating point number with 4 decimal places (for example, 40.0000) in PowerServer.