On 2 Mar 2001, at 16:42, Jörg Schiemann wrote:

To: <ib-support@yahoogroups.com>
From: Jörg Schiemann <schimmi@...>
Date sent: Fri, 2 Mar 2001 16:42:33 +0100
Send reply to: ib-support@yahoogroups.com
Subject: Re: [ib-support]


This was the winning combination:

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

Thanks Guys....


> 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
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>


Paul Schmidt,
Tricat Technologies
Email: paul@...
Website: www.tricattechnologies.com