It's not possible in the query, but I wonder if there's a UDF you
could write that takes in the name of a table, and then a list of
columns NOT to show, and outputs a string of comma-separated values.
That'd be neat, so then you could write:
SELECT allBut(mytable,badfield1,badfield2,. . .) FROM m
Oops, I meant to send this to the original poster _and_ the list :-)
Rhino
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Frank Rust" <[EMAIL PROTECTED]>
Sent: Friday, December 09, 2005 9:02 AM
Subject: Re: SELECT all except ... ?
--
Frank Rust <[EMAIL PROTECTED]> wrote on 12/09/2005 01:59:35 AM:
> Is there a possibility to select all columns from a table except one or
> two columns? For example I have a table with 30 columns and want all
> columns but one column *not*. Do I have to write a very long select
> statement with
On 09/12/05, Frank Rust <[EMAIL PROTECTED]> wrote:
> Is there a possibility to select all columns from a table except one or
> two columns? For example I have a table with 30 columns and want all
> columns but one column *not*. Do I have to write a very long select
> statement with 29 column names
Is there a possibility to select all columns from a table except one or
two columns? For example I have a table with 30 columns and want all
columns but one column *not*. Do I have to write a very long select
statement with 29 column names that i want to get?
--
___