Svein,

I couldn't remember if it was "|" or "||". I just remembered that it
wasn't "+" so you are probably right that it should be "||".

Gerald S. Brown

--- In IBObjects@y..., Svein Erling Tysvær <svein.erling.tysvaer@k...>
wrote:

> 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...
> >
> >
> >
> >
> >
> >