title: How can I select * from table, but cast one of the columns to a different datatype?
body: <p>I have a table with several columns.  I want to do essentially:</p>
  
  <pre><code>select * from myTable and CAST(COLUMN1 as INT) where STUFF
  </code></pre>
  
  <p>and get all the columns as well as my first column casted as an int.  Obviously this does not work.  </p>
  
  <p>I know I can do the following, but its not portable whatsoever incase I need to add more columns or what have you. This is so heavy handed, and it makes my sql statements extremely long.  </p>
  
  <pre><code>select (CAST COLUMN1 as INT), COLUMN2, COLUMN3, COLUMN# from TABLE where STUFF
  </code></pre>
  
  <p><strong>So my question is simply, can I query all rows and columns and just cast one of them?</strong></p>
  
  <p>If it matters, I am using DB2.</p>
  
  <p><strong>EDIT: I just tried to run the command listing out all the columns and SQuirreL wont even execute it.</strong></p>