decimal(9.2)

Hello

How do I define the datatype decimal(9.2). I searched the documentation
but the only thing I found was the money data type which is in my case
not very usefull.

Is there a way to declare a datatype with 2 decimal places and with a fixed
precision? Thanks for your help

Herbie

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti                            E-Mail: Herbert.Liechti@thinx.ch
ThinX networked business services               Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~