Hi all,

Is it possible to concatenate the columns of the results of a query
without having to run it through an external filter?

For examples, if I have
select col-A, col-B, col-C, col-D from my_table.

Can I write the query such that col-A, col-B and col-C come out
concatenated? Yes, they're the same data type.

So I'm looking for something like
select col-A + col-B + col-C, col-D where "+" is a concatenation
operator.

Thanks a lot!
Sashi

"Sashi" <smalladi (AT) gmail (DOT) com> wrote

select col-A || col-B || col-C, col-D

--
Terry Dykstra

On Oct 18, 4:02 pm, Sashi <small... (AT) gmail (DOT) com> wrote:
To answer my own question, I figured out that I can use the "||"
operator or the concat function.

On Oct 18, 4:02 pm, Sashi <small... (AT) gmail (DOT) com> wrote:
To answer my own question, I figured out that I can use the "||"
operator or the concat function.