Subject RE: [firebird-support] SQL Question
Author Nigel Weeks
Bizarre – it works for me:

SQL> select cast('now' as timestamp) as "henry smith" from rdb$database;

henry smith

2007-04-19 17:17:05.0000



Nigel Weeks
Tech Support and Systems Developer
Rural Press Tasmania
The Examiner Newspaper
Ph. 03 6336 7234
Mob. 0408 133 738
Email.  nweeks@...
[] On Behalf Of Peter Dennis
Sent: Thursday, 19 April 2007 5:11 PM
Subject: RE: [firebird-support] SQL Question

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"

[] On Behalf Of Helen Borrie
Sent: Thursday, 19 April 2007 4:53 PM
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:
> col1 AS "Student Name"
> students
> studentID = 7577;


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

__________ NOD32 2202 (20070418) Information __________

This message was checked by NOD32 antivirus system.