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.
>
>