Re: Concat

[Tara K <tkurtz999@HOTMAIL.COM>]

Perform your SELECTS... place your MOVE or LET statements before the FROM
statement. Example below:

Begin-Select
X.entrysource
X.entryrefnum

     MOVE &x.entrysource to $entrysource
     MOVE &x.entryrefnum to $entryrefnum

     LET $AccountNo = $entrysource || $entryrefnum


FROM entrylogdt X
WHERE.....
AND...

Its been awhile for me... however, this should do the trick.

Sincerely,
Tara Kurtz
Tampa, Florida


>From: Adam Harborow <adam.harborow@ZURICH.COM>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Concat
>Date: Wed, 14 Feb 2001 10:47:05 +0000
>
>Hello
>
>I am using BRIO Report builder 6, Windows NT 4.0, Oracle 7.3.4.
>
>I have 2 fields in the same table that I need to join together.  I can do
>it in SQL:
>
>SELECT entrysource || '' || entryrefnum AS Accountno
>FROM entrylogdt
>
>I have tried to do something similar in SQR/Brio reportbuilder by using
>either Concat or Let (reading the SQR manual), but as yet I have failed.
>If it is a Concat statement where should it go ie after Begin-Select or
>after WHERE etc.
>
>Thanks
>
>Adam

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com