SELECT col1, col2, col3, CAST(NULL as BIT) as newCol4, CAST(NULL as VARCHAR(6)) as newCol5 FROM yourTable
in this example, newCol4 and newCol5 are your non-existent columns. Using the CAST, ensures that they are the correct datatype, but you could also use either of these methods:
SELECT col1, col2, col3, NULL as newCol4, '' as newCol5 FROM yourTable
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.Jason L. Selburg