Hi,

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

What trailing zeroes are there on a number? Exactly: none.

This is a display issue, not a "value" issue.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com