Is there some kind of syntax in SQL which allows you to select most of the
columns from a table without selecting them all.

IOW, if you have a table with 25 columns, and you want 22 of them in your
result set, can you do something like:



Select (* - SuperfluousVal, SuperfluousVal2, SuperfluousVal3) from .



.rather than explicitly listing the 22 columns?



Listing the 22 columns explicitly is a pain; grabbing all 25 using "SELECT
*" is wasteful.



Clay Shannon,

Dimension 4 Software





[Non-text portions of this message have been removed]