Selecting out certain columns

Let's say you have a table with 50 columns and you want to retrieve data that lists only 49 of those columns. Is there any easy way to do this without typing: select column1, column2,...column49 from table. So basically is there a way to select out certain columns in your statement while retrieving the rest of the columns?

Thanks Received on Thu May 02 2002 - 13:33:13 CDT