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