John,
There is no except function in SQL. You would have to individually specify the fields you want.
PF
>Hey all!!
>Is there a way to do a SQL-SELECT in which I pull all the fields from the database(26 fields) except for 3?
>
>TIA:)
(On an infant's shirt): Already smarter than Bush