Thanks for the help both of you......

I now see where I went wrong, What is the difference between DECIMAL and NUMERIC ....?

Cheers

Colin

--- In firebird-support@yahoogroups.com, "Ann W. Harrison" <aharrison@...> wrote:
>
> Ann W. Harrison wrote:
>
> >
> > The 6 in decimal(6,2) is the precision. It includes the
> > decimal digits. So the legal range is not -999,999.99 to
> > +999,999.99 but -999,999 to +999,999 and the scale factor
> > is added later by multiplying by 10 to the scale factor
> > minus one.
>
> left out the word 'times' in the description
>
> value = <stored value> * 10^(<scale factor> * -1>)
>
> 123.45 = 12345 * 10^-2
>
> Ann
>