pls help

Hi All
I have table Tb1 with 2 columns ColA and Colb with rows as below:
ColA ColB
a 1
b 2
How can i query Tb1 to bring a result set of ColB only as another set of
columns as below:
Col(i) Col(ii)
1 2
Thanx in advance.http://aspfaq.com/show.asp?id=2462
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:68702DCE-1A9B-4EB8-AF73-A77912999191@.microsoft.com...
> Hi All
> I have table Tb1 with 2 columns ColA and Colb with rows as below:
> ColA ColB
> a 1
> b 2
> How can i query Tb1 to bring a result set of ColB only as another set of
> columns as below:
> Col(i) Col(ii)
> 1 2
> Thanx in advance.