How to create a column of a specific type?

Question

How would I add a column to a Select and have that column be of a specific type.

For example Select Company, City, Dues, 0 As NewColumn1, 123.12 As NewColumn2 But I want NewColumn1 to be of type bit, and NewColumn2 to be of type Real

Oh, I'm using SQL Server 2005.

Answer 1

You can use CAST

Select  Company,    
        City, 
        Dues, 
        CAST(0 AS BIT) As NewColumn1, 
        CAST(123.12 AS REAL As NewColumn2 
FROM    @Table

Have a look at CAST and CONVERT (Transact-SQL) .