Adding columns with Fixed value

[wutaguy]

I have a query that gives me a table with one column, say column A.
I need to add 2 columns to the table and the coulmns will have fixed value.
So I need to add column B and column C to my table and all rows in column B will have a fixed value and all rows in column C will have a fixed value.

What I have:
Table with one column
Column A
a
b
c

What I need:
Table with 3 columns:
ColumnA Column B Column C
a 12 14
b 12 14
c 12 14

Any help will be greatly appreciated.
Thanks

 

[pbaldy]

SELECT ColumnA, 12 AS ColumnB, 14 AS ColumnC
FROM TableName