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

At 08:49 AM 11/12/2003 +0100, you wrote:

> > How do I concatenate two fields in a select statement with extra
> charcaters
> > ? the following all throw errors.
> >
> > SELECT Field1 + '(' + Field2 + ')'
> > FROM Table;
> >
> > SELECT Field1 & '(' & Field2 & ')'
> > FROM Table;
> >
> > SELECT Field1 + "("+ Field2 + ")"
> > FROM Table;
> >
> > SELECT Field1 & "(" & Field2 & ")"
> > FROM Table;
> >
> > SELECT CONCAT(Field1,Field2)
> > FROM Table;
>
>Use the double pipe symbol ||.
>
>SELECT Field1 || '(' || Field2 || ')'
>
>Be aware, if one of the arguments is NULL, the entire concatenation
>will be NULL.
>
>
>Best Regards,
>Thomas Steinmaurer
>
>Logging/Auditing Suites for InterBase, Firebird and Advantage Database Server
>http://www.iblogmanager.com
>http://www.adslogmanager.com
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/