split columns to rows?

[r0brh0des]

I am looking for a way to take the columns for an id to separate rows.

Ex.

Existing Table:

ID COL1 COL2 COL3
1 a b c
2 d e f

Desired Query Result:

ID COL
1 a
1 b
1 c
2 d
2 e
2 f

Thanks!

 

[gmmastros]

Select ID, Col1
From   Table

Union All 

Select ID, Col2
From   Table

Union All

Select ID, Col3
From   Table

-George

"the screen with the little boxes in the window." - Moron