> Is there a way to give the new concatenation a new name ?

Column aliases even work with concatenated fields. ;-)

SELECT (Field1 || '(' || Field2 || ')') as NEWNAME
FROM ...


Best Regards,
Thomas Steinmaurer

Logging/Auditing Suites for InterBase, Firebird and Advantage Database Server
http://www.iblogmanager.com
http://www.adslogmanager.com