|
|
Posted by Tom van Stiphout on 01/02/08 14:32
On Wed, 2 Jan 2008 01:31:21 -0800 (PST), Ganapathi sundaram
<ganapathysundarum@gmail.com> wrote:
How about this:
select empid, empname, address1 + CHAR(13) + CHAR(10) + address2
from employee
-Tom.
>Dear All,
>
>I want to get more than one table columns as a single column by
>alternative.
>
>For eg,
>
>Table name = employee
>
>columns = empid, empname, address1,address2
>
>Here, I want to interpolate the address2 column on address1 as
>mentioned below,
>
>empid empname address1
> address2
>
>1 aaa First Layout,
> CA, US.
>
>
>Thanks in advance.
>
>Thanks and Regards,
>Ganapathi sundaram.G
Navigation:
[Reply to this message]
|