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.