On Oct 18, 4:02 pm, Sashi <small..._at_gmail.com> wrote:
> 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
To answer my own question, I figured out that I can use the "||"
operator or the concat function.
Received on Thu Oct 18 2007 - 15:32:04 CDT
