Hi,

you have to use "||" instead of "+":

FS.SUITE || " " || FS.BLOCK || " " || FS.STREET AS FSADDR

Note: If one field is NULL then FSADDR will be NULL, too.

HTH,
Markus

At 10:29 02.03.2001 -0500, you wrote:

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,

I want this to appear in the query

'503 2534 Main Street E'

in FSADDR.