Posted by Dan Guzman on 10/23/05 20:03

No, there is no Transact-SQL syntax for this. However, you can use Query
Analyzer to generate a SELECT statement for the desired view or table and
then remove the unneeded columns.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"ric" <rtavert@yahoo.com> wrote in message
news:1130086527.567870.112960@z14g2000cwz.googlegroups.com...
> Hi,
>
> Is there a way to exclude fields in a query other than just including
> the ones you want. If there are 20 fields and you want to see all but
> 3, it would be a lot easier to exclude the 3.
>
> Thanks
>

[Back to original message]