Re: Concatenate columns

"Sashi" <smalladi_at_gmail.com> wrote in message news:1192737759.970098.290020_at_e9g2000prf.googlegroups.com...
> 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
>

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

-- 
Terry Dykstra