getting column data

[krc777]

I have a table with data from many months as follows:

Jul-06 Aug-06 Sep-06
.32 .55 .64
.44 .75 .52
.56 .33 .48

I want to place the data from just column Sep-06 in another table. Is there an SQL statement I could write to do something like:

select * from trenddata where column = [sep-06]

thanks,