Hi,

I have one Double precision field. with select statement it comes with dot and trailing zeroes. Why?

Select
A.AIDAT_UYEKODU,
U.UYE_UYEADSOYAD,
(A.AIDAT_UYEKODU||' '||U.UYE_UYEADSOYAD) as KODADSOYAD

from AIDAT A
JOIN UYE U
ON ( A.AIDAT_UYEKODU = U.UYEKODU)



CREATE TABLE AIDAT (
AIDAT_UYEKODU DOUBLE PRECISION NOT NULL,




Result of KODADSOYAD

232365.0000000000 ozzy genco
232365.0000000000 ozzy genco
232367.0000000000 abx sas
23123123.00000000 re werwer
23123123.00000000 re werwer
23123123.00000000 re werwer
23123123.00000000 re werwer



Required Result

232365 ozzy genco
232365 ozzy genco
232367 abx sas
23123123 re werwer
23123123 re werwer
23123123 re werwer
23123123 re werwer

What Can I do for this?


[Non-text portions of this message have been removed]