Luc,

Thank you, I succeded. The thing which works is

(CAST ((CENOVNIK.SP*83.00*1.18/1.00) AS DECIMAL(15,2))) AS MPC +
format string you adviced. Now also Hellen's advice works.

Field SP is DOUBLE PRECISION.

Once again, thanks.

Regards,

Zoran Zivkovic

--- In IBObjects@yahoogroups.com, Lucas Franzen <luc@r...> wrote:
> Zoran,
>
> Zoran Zivkovic schrieb:
>
> >
> > Luc,
> >
> > I just tried this also , and I receive a error:
> > '543.567' is not valid integer value. (value of column I want to
> > format).
>
> I don't know the field type of CENOVNIK.SP, you do:
>
> SELECT DISTINCT PARTNO
> , EAPARTNO
> , FILTER_TYPE
> , COMMENT
> , ((CENOVNIK.SP*83*1.18)/1) AS MPC
> FROM FILTER_PARTS
> LEFT OUTER JOIN CENOVNIK ON
(FILTER_PARTS.EAPARTNO=CENOVNIK.EAPARTNO)
>
> but certainly this field causes the trouble.
>
> Try
> ((CENOVNIK.SP*83.00*1.18)/1.00) AS MPC
>
> (Dialect 3 will use the lowest precision you "declared", so
multiplying
> by 83 and dividing by 1 will result in an integer --> changing to
83.00
> and 1.00 might help)
>
> or try to cast the whole thing:
> , CAST ( ((CENOVNIK.SP*83.00*1.18)/1.00 AS DOUBLE PRECISON))
AS MPC
>
>
>
> Luc.