Hi Paul,

try FS.SUITE || ' ' || FS.BLOCK || ' ' || FS.STREET AS FSADDR,

HTH
Jörg

----- Original Message -----
From: Paul Schmidt
To: ib-support@yahoogroups.com
Sent: Friday, March 02, 2001 4:29 PM
Subject: Re: [ib-support]


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