bsmith 63193 (10/7/2015)
What about specifying a specific value for a column in all rows?
SELECT col1, col2, col3, 0 as newCol4, 'ABC' 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