Select all fields except one

["Matt Doughty" <matt.doughty@xxxxxxxxxxxx>]

Hi,

Is there a way of selecting all fields except for one in particular? I'd like to create a query that says something like:

 

select * except fieldx

 

What I’m hoping to achieve is a query that can be valid for a number of different tables, although the field I don’t want to select is always called the same (field_not_wanted, for example). I’ve been told that an array could work in this case but I’m not reallly sure about how to go about this.  

 
Cheers,

Matt

 

 

Matt Doughty
GEOGRAMA S.L.
Tel.:  +34 945 13 13 72    652 77 14 15
Fax: +34 945 23 03 40
www.geograma.com