Position of Table Columns

[Ganapathi sundaram]

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,addres s2

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

[Tom van Stiphout]

On Wed, 2 Jan 2008 01:31:21 -0800 (PST), Ganapathi sundaram
<ga************ ***@gmail.comwr ote:

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,addres s2

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

[--CELKO--]

>I want to get more than one table columns as a single column by alternative. <<

Formatting is done in the front end in a tiered architecture, never in
the database. This is a basic programming concept and applies to more
than just SQL.

[Madhivanan]

On Jan 2, 2:31*pm, Ganapathi sundaram <ganapathysunda [e-mail]>
wrote:

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,addres s2

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

Where do you want to show data?
It seems you should use Reports