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

Although it may seem a pain what would happen to your code if in the future
another dba added a varchar(32000) and later a blob column to the table,
your exclusion list will not include these columns and you have the
potential impair performance or add anomalies to your code.

Personally I would never advocate the use of SELECT * FROM ... As you never
know what will happen in the future to the table schema, however, that said
why not create a view using your 22 columns and select * from the view (if
you do not want to list the columns). At least then you know that the view
only contains those columns that you need/require.

Rgds

Si Carter
http://www.fbtalk.net/
http://www.tectsoft.net/