Gerald,
I think you mean
SELECT A, B, A||B as C

I thought he was adding numbers...

Set

At 12:44 30.01.2001 -0000, you wrote:

>Have you tried:
>SELECT A, B, A|B as C
>I remember reading somewhere that IB doesn't like to add strings. It
>needs to concatinate them.
>
>Gerald S. Brown
>
>--- In IBObjects@y..., "Jaroslav KULHEIM" <kulheim@f...> wrote:
>> Hi all,
>>
>> SELECT A, B, A+B as C FROM anytable
>>
>> If C is DbText value isn't displayed in ReportBuilder,
>> but if C is DbCalc value of C is displayed.
>>
>> Can you test this simple query - don't know if it's IBO, IBO
>pipeline or RB
>> related problem.
>>
>> RB5.0, IBO3.6.A, D4
>>
>> thank you for your answer,
>>
>> Jaroslav Kulheim
>> kulheim@f...
>
>
>
>
>
>