Hi Paul,

use || to concatenate fields.

Hope it helps

Robert



Paul Schmidt schrieb:

>
> Hi All:
>
> Okay this falls into the "dumb question" category, but it's bugging me:
>
> I am in the midst of a Paradox to IB conversion and the following worked under Paradox but doesn't work under IB.
>
> FS.SUITE + " " + FS.BLOCK + " " + FS.STREET AS FSADDR,
>
> What I have here is an address stored as follows:
>
> FS.SUITE = '503'
> FS.BLOCK = '2534'
> FS.STREET = 'Main Street E.'
>
> I want this to appear in the query
>
> '503 2534 Main Street E'
>
> in FSADDR.
>
> The fields are ALL defined as VARCHAR, do I need some kind of concatenate function? I didn't see anything in the IB docs, but the docs I have are anything but complete.
>
> I am using Firebird for Windows V0.9.4.41
>
> Paul Schmidt, Tricat Technologies Email: paul@... Website: www.tricattechnologies.com