At 09:06 AM 15/08/2005 +0800, you wrote:

>Thanks.
>But a new problem found.
>Cast (Value1 as numeric(9,2)),Value1= 13.275,reuslt is 13.27;
>Cast (Value2 as numeric(9,2)),Value2= 13.228,reuslt is 13.23;
>what is the rule to round?

It uses banker's rounding. But you get different results to what I get.

select
cast(13.275 as numeric(9,2)) as result from rdb$database
returns 13.28

select
cast(13.228 as numeric(9,2)) as result from rdb$database

returns 13.23

I'm using Fb 1.5.2 (build 4731) on Win2K. What are you using? What are
you using to view results?

./heLen