Concat

[Adam Harborow <adam.harborow@ZURICH.COM>]

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