Hi Michael

--- In firebird-support@yahoogroups.com, "Michael Vilhelmsen"

> I would then like to select all fields except field37 i.e.

I vaguely recall that there are SQL dialects, where you can
dynamically generate a SQL statement by means of SQL, most
usefully with queried metadata tables.

Pseudo-SQL which will certainly work nowhere:

EXECUTE
'SELECT ' ||
(SELECT colname FROM meta$columns
WHERE table = 'tbl1' AND colname != 'field37
AS STRING DELIMITER ',') ||
'FROM tbl1' ;

Regards,
Peter Jacobi