Transposing Data of Table as Columns in SQL

[TimHop12]

Lets consider the following query:

Select Col1, Col2 from Table1 where Colx = 'A5100650867'

This gives result as:

Col1                         Col2
E-mail Address                [e-mail]
Web Site                      www.GOOGLE.com

I want the outcome as:

E-mail Address         Web Site
[e-mail]           www.GOOGLE.com

So the new columns inthe resultset are 'E-mail Address' and 'Web Site'.

[HTML]Note: This is just a simple example I have considered. Potentially there can be multiple things like that e.g. E-Mail, E-Mail2, Pager, Mobile etc etc...[/HTML]

Please advice on this. Thank you.

[dusana]

Lets consider the following query:

Select Col1, Col2 from Table1 where Colx = 'A5100650867'

This gives result as:

Col1                         Col2
E-mail Address                [e-mail]
Web Site                      www.GOOGLE.com

I want the outcome as:

E-mail Address         Web Site
[e-mail]           www.GOOGLE.com

So the new columns inthe resultset are 'E-mail Address' and 'Web Site'.

[HTML]Note: This is just a simple example I have considered. Potentially there can be multiple things like that e.g. E-Mail, E-Mail2, Pager, Mobile etc etc...[/HTML]

Please advice on this. Thank you.

try this

Select ltrim(rtrim(Col1)) as Col1, ltrim(rtrim(Col2)) as Col2 from Table1 where Colx = 'A5100650867'