Thanks Helen.

Sorry about the non-plain text message before.

How do i do this kind of query when using the Firebird ISQL Tool?

I get this error for the following query:

SQL> select subu_name As "Suburb Name" from suburb where subu_id = 2000;
Statement failed, SQLCODE = -104
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 21
-"Suburb Name"

________________________________________
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
Sent: Thursday, 19 April 2007 4:53 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] SQL Question

At 03:43 PM 19/04/2007, you wrote:

>Hi all,
>
> I was just wondering whether this is the correct group to ask about SQL
>queries? If not can someone please point me in the right direction?
>
>Is it possible in Firebird to use column aliases in a select statement?
>
>For example:
>
>SELECT
> col1 AS "Student Name"
>FROM
> students
>WHERE
> studentID = 7577;

Yes.

Would you please configure your mail client to send plain text to the
lists? thanks.
^ heLen