Subject Re: [ib-support] How to join two string
Author Rotandiko Sastroprawiro
Thanks very much. btw where i can find the documentation about all operator at
Firebird. I have read Data Definition and Language Reference but did'nt find about that
Thanks,
Diko
Helen Borrie <helebor@...> wrote:At 03:34 AM 24/01/2003 +0000, you wrote:
>Dear All,
>How to join string ='test' and string = 'content' ?
>I have tried with operator "+", but it's didn't work.

The string concatenation operator is ||

select 'test' || 'content' as mytest from rdb$database

In SQL, '+' is an arithmetic operator.

heLen






---------------------------------
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!

[Non-text portions of this message have been removed]