Thanks Alan! We'll give it a try.

Is this dependent on the version of FB the client is using? I think they are still on FB 1.5.

--- In firebird-support@yahoogroups.com, Alan J Davies <Alan.Davies@...> wrote:
>
> That will work.
> Here's a real-life example I just changed using your question:
> select
> ii.partno,sum(ii.inv_qty),extractweekday(ih.inv_date),ih.inv_date,ih.acno
> "account number"
> from invhead ih
> join invitems ii
> on ii.inv_nmbr=ih.inv_nmbr
> group by ii.partno,ih.inv_date,ih.inv_date,ih.acno
>
> select
> ii.partno,sum(ii.inv_qty),extractweekday(ih.inv_date),ih.inv_date,ih.acno as
> "account number"
> from invhead ih
> join invitems ii
> on ii.inv_nmbr=ih.inv_nmbr
> group by ii.partno,ih.inv_date,ih.inv_date,ih.acno
>
> Note that you do not require the "AS" although it may help with readability.
>
> Alan J Davies
> Aldis
>
> On 19/04/2013 16:14, ramona.grissom wrote:
> > How can we accomplish this in Firebird?
> >
> > In MSSQL for example you can SELECT column AS [column name]. The "column
> > name" can contain spaces and be named a reserved word because it's
> > escaped with the square brackets.
> >
> > But not sure about
> >
> > SELECT CustomerName AS "Customer Name"
> > FROM Customers
> >
> > Thank you in advance for your help.
> >
> >
>