Thank you for your reply

I choosed BIGINT instead of INTEGER

(cast(A.AIDAT_UYEKODU as BIGINT)

----- Original Message -----
From: ""Svein Erling"" <svein.erling.tysvaer@...>
Newsgroups: egroups.ib-support
To: <firebird-support@yahoogroups.com>
Sent: Thursday, February 05, 2004 11:04 AM
Subject: [firebird-support] Re: Select comes with zeroes


> Select
> A.AIDAT_UYEKODU,
> U.UYE_UYEADSOYAD,
> (cast(A.AIDAT_UYEKODU as integer)||' '||U.UYE_UYEADSOYAD) as
> KODADSOYAD
> from AIDAT A
> JOIN UYE U
> ON ( A.AIDAT_UYEKODU = U.UYEKODU)
>
> Thanks for describing your problem very clearly!
>
> Set