> Will a decimal(9,2) maintain the trailing zeros on say, a monetary value?
>
> I need 10.10 not 10.1, for example.

Database stores *values*, and maintains *precision/scale*.

*Trailing zeroes* are *formatting* properties, which is normally
done on client side. When formatting monetary values,
you would also have to specify decimal separator,
thousands separator, currency symbol, negative numbers
format, leading zero suppression, arabic/roman numbers etc.
Database server has better things to do ...

Ivan
http://www.volny.cz/iprenosil/interbase/